68c376cf23864: POST https://beta.jinchangxiao.com/vue/erp-other-collect-ticket/search-approve at 2025-09-12 09:26:39 am by 114.246.237.213
Database Queries
总计30条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 09:26:39.148 | 2.3 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 09:26:39.152 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:26:39.155 | 0.8 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id" |
| 09:26:39.156 | 4.1 ms | SELECT | SELECT COUNT(*) FROM (SELECT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_cancel_verify_rels" "rcvr" ON rcvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id 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)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001) OR ("rcvr"."user_id"=1001)) AND ("r"."supplier_id"='511') AND ("r"."status"=2) AND ("dt1"."taxonomy_id"=2100000001) AND (r.erp_borrow_un_settle_amount > 0) GROUP BY "r"."id" ORDER BY r.created_at DESC) "c" |
| 09:26:39.161 | 2.7 ms | SELECT | SELECT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_cancel_verify_rels" "rcvr" ON rcvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id 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)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001) OR ("rcvr"."user_id"=1001)) AND ("r"."supplier_id"='511') AND ("r"."status"=2) AND ("dt1"."taxonomy_id"=2100000001) AND (r.erp_borrow_un_settle_amount > 0) GROUP BY "r"."id" ORDER BY r.created_at DESC |
| 09:26:39.164 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011 |
| 09:26:39.165 | 0.6 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011) |
| 09:26:39.165 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3 |
| 09:26:39.166 | 19.4 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id"=2218) GROUP BY "object_id" |
| 09:26:39.185 | 16.8 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"=2218) GROUP BY "object_id" |
| 09:26:39.202 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=2218 |
| 09:26:39.203 | 0.4 ms | SELECT | SELECT "id", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (5, 135, 154, 184, 189, 2100000001, 349, 377)) |
| 09:26:39.203 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id"=2218 |
| 09:26:39.204 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5388, 1013) |
| 09:26:39.204 | 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)) |
| 09:26:39.205 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id"=2218 ORDER BY "id" |
| 09:26:39.205 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:26:39.206 | 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) |
| 09:26:39.206 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id"=2901) |
| 09:26:39.208 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id"=2901) |
| 09:26:39.210 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id"=2218) ORDER BY "id" |
| 09:26:39.210 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id"=2218) ORDER BY "id" |
| 09:26:39.211 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id"=2218) |
| 09:26:39.213 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=27912 |
| 09:26:39.214 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=511 |
| 09:26:39.215 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id"=2218) |
| 09:26:39.216 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=27916 |
| 09:26:39.217 | 3.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-12') |
| 09:26:39.221 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=71, "last_visit_at"='now()' WHERE "id"=56537 |
| 09:26:39.222 | 1.3 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/erp-other-collect-ticket/search-approve', '{"supplier_id":"511","purchase_contract_id":"","web_access_token":"2BZqbE639wqIoHhgH0VfUgn-meZYtkbz"}', '{"code":2000,"result":{"list":[{"id":2218,"client_id":"","project_id":"","title":"\u6295\u6807\u4fdd\u8bc1\u91d1\u7533\u8bf7-\u5317\u4eac\u80bf\u7624\u533b\u9662\u7f51\u7edc\u5b89\u5168\u8bbe\u5907\u66f4\u65b0\u91c7\u8d2d\u9879\u76ee","status":2,"next_verify_user":"","verify_at":"2025-08-29 13:36:15","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u5317\u4eac\u80bf\u7624\u533b\u9662\u7f51\u7edc\u5b89\u5168\u8bbe\u5907\u66f4\u65b0\u91c7\u8d2d\u9879\u76ee\u6295\u6807\u4fdd\u8bc1\u91d1\uff08\u5bf9\u65b9\u5df2\u628a\u8d44\u91d1\u6c47\u6b3e\u81f37062\u5361\u53f7\uff09\uff0c\u91d1\u989d\uff1a\uffe524000\uff0c\u8bf7\u5ba1\u6279\uff01\n\u62db\u6807\u4fe1\u606f\uff1ahttp:\/\/www.ccgp-beijing.gov.cn\/xxgg\/sjxxgg\/zbgg\/2025\/8\/28d99dd763a04a53a60468f8b4c91b38.htm\n\n\u6c47\u6b3e\u4fe1\u606f\uff1a\n\u6237\u540d\uff1a\u4e2d\u6280\u56fd\u9645\u62db\u6807\u6709\u9650\u516c\u53f8\n\u865a\u62df\u5b50\u8d26\u6237\uff1a78202508297723\n\u94f6\u884c\uff1a\u5e73\u5b89\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u795e\u534e\u652f\u884c\n\u6c47\u6b3e\u7528\u9014\uff1a\u9879\u76ee\u7f16\u53f7\uff1a11000025210200134428-XM006\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u501f\u6b3e\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-08-29 12:22:22","updated_at":"2025-08-29 13:36:15","supplier_id":511,"purchase_contract_id":"","amount":"","borrow_amount":"24000","borrow_collect_day":"2025-09-30","borrow_collect_status":0,"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":"24000","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2218,"comment":4},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":7869,"approve_id":2218,"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"}}},{"id":7870,"approve_id":2218,"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"}}}],"approveVerifyRels":[{"id":2901,"approve_id":2218,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-29 13:36:15","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":"","haveApproveVerifyRel":{"id":2901,"approve_id":2218,"user_id":1001,"status":1,"description":"","verify_at":"2025-08-29 13:36:15"},"attachmentRelationships":[{"id":49415,"object_type":28,"object_id":2218,"attachment_id":27912,"attachment":{"id":27912,"key":27912,"name":"6f5f0730-bfd5-30e3-902d-dc78b979676b","extension":"jpg","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2025\/08\/","orig_name":"5161756440878_.pic.jpg"}}],"client":{},"project":{},"supplier":{"id":511,"key":511,"name":"\u5317\u4eac\u610f\u7545\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseContract":"","files":[{"id":49416,"object_type":29,"object_id":2218,"attachment_id":27916,"attachment":{"id":27916,"key":27916,"name":"b757600f-d4bf-38d0-84f6-34a722c41558","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2025\/08\/","orig_name":"2025_08_29_12_21_36.pdf"}}],"checked":false,"serial_no":""}],"can_create":true,"pagenation":{"totalcount":1,"thispage":1,"pagesize":-1}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-12 09:26:39') RETURNING "id" |