6a2a6a726f704: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-unit-other-collect at 2026-06-11 03:57:38 pm by 221.216.117.119
Database Queries
总计15条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 15:57:38.461 | 0.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 15:57:38.463 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:57:38.467 | 1.5 ms | SELECT | SELECT COUNT(*) FROM (SELECT * FROM (SELECT r.id, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.handler, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_paid_amount, false as is_payment_settle, r.created_at, r.ticket_type as t_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.bank_settle_at IS NOT NULL) AND ("r"."supplier_id"='431') AND (r.amount - r.settle_amount > 0)) "sub" ORDER BY created_at DESC) "c" |
| 15:57:38.468 | 0.6 ms | SELECT | SELECT * FROM (SELECT r.id, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.handler, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_paid_amount, false as is_payment_settle, r.created_at, r.ticket_type as t_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.bank_settle_at IS NOT NULL) AND ("r"."supplier_id"='431') AND (r.amount - r.settle_amount > 0)) "sub" ORDER BY created_at DESC LIMIT 40 |
| 15:57:38.470 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:57:38.470 | 0.5 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 15:57:38.471 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4 |
| 15:57:38.472 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:57:38.472 | 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:57:38.473 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4 |
| 15:57:38.473 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431 |
| 15:57:38.474 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4498 |
| 15:57:38.474 | 0.5 ms | SELECT | SELECT SUM(un_paid_amount) FROM (SELECT r.id, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.handler, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_paid_amount, false as is_payment_settle, r.created_at, r.ticket_type as t_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.bank_settle_at IS NOT NULL) AND ("r"."supplier_id"='431') AND (r.amount - r.settle_amount > 0)) "sub" |
| 15:57:38.475 | 0.4 ms | SELECT | SELECT COUNT(*) FROM (SELECT r.id, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20021 as ticket_type, r.abstract, r.description, r.created_by, r.handler, r.amount, r.status, r.settle_amount, r.amount - r.settle_amount as un_paid_amount, false as is_payment_settle, r.created_at, r.ticket_type as t_type FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "r" WHERE ("r"."status"=2) AND (r.bank_settle_at IS NOT NULL) AND ("r"."supplier_id"='431') AND (r.amount - r.settle_amount > 0)) "sub" |
| 15:57:38.477 | 1.7 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-unit-other-collect', '{"supplier_id":"431","page":"1","pageSize":"40","listReload":"true","web_access_token":"2SCKb3BYAaSLDxSx0sIX1KfVKBB-1lWj"}', '{"code":2000,"result":{"list":[{"id":60,"supplier_id":431,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":4498,"wrote_date":"2026-06-11","serial_no":"QTYSD-20260611-00004","ticket_type":20021,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"200","status":2,"settle_amount":"0","un_paid_amount":"200","is_payment_settle":false,"created_at":"2026-06-11 15:26:44","t_type":1,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":{"id":4498,"key":4498,"name":"\u6d4b\u8bd5\u5176\u4ed6\u5e94\u6536\u5355"},"ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contract_no":"\u6d4b\u8bd5\u5176\u4ed6\u5e94\u6536\u5355","t_type_display":"\u4ed8\u62bc\u91d1"},{"id":58,"supplier_id":431,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":4498,"wrote_date":"2026-06-11","serial_no":"QTYSD-20260611-00002","ticket_type":20021,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"8000","status":2,"settle_amount":"0","un_paid_amount":"8000","is_payment_settle":false,"created_at":"2026-06-11 15:14:31","t_type":1,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":{"id":4498,"key":4498,"name":"\u6d4b\u8bd5\u5176\u4ed6\u5e94\u6536\u5355"},"ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"contract_no":"\u6d4b\u8bd5\u5176\u4ed6\u5e94\u6536\u5355","t_type_display":"\u4ed8\u62bc\u91d1"}],"total":"8200","count":2,"pagenation":{"totalcount":2,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-11 15:57:38', 19366144) RETURNING "id" |