ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2a6a6fd3af9: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-unit-other-payment at 2026-06-11 03:57:35 pm by 221.216.117.119

Database Queries

总计15条数据
TimeDurationTypeQuery
  
15:57:35.8721.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
15:57:35.8750.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
15:57:35.8802.0 msSELECTSELECT COUNT(*) FROM (SELECT * FROM ((SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id 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, 20020 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_payment_tickets" "r" WHERE ("r"."status"=2) AND ("r"."supplier_id"='431') AND (r.amount - r.settle_amount > 0)) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, r.contact_id as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, null::integer as 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, null::integer as t_type FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" WHERE ("r"."status"=2) AND ("r"."supplier_id"='431') AND (r.amount - r.settle_amount > 0) ) UNION ALL ( SELECT (r.id::varchar || 20021::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id 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, 0::numeric as settle_amount, r.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 NULL) AND ("r"."supplier_id"='431') )) "sub" ORDER BY created_at DESC) "c"

[+] Explain
15:57:35.8821.7 msSELECTSELECT * FROM ((SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id 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, 20020 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_payment_tickets" "r" WHERE ("r"."status"=2) AND ("r"."supplier_id"='431') AND (r.amount - r.settle_amount > 0)) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, r.contact_id as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, null::integer as 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, null::integer as t_type FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" WHERE ("r"."status"=2) AND ("r"."supplier_id"='431') AND (r.amount - r.settle_amount > 0) ) UNION ALL ( SELECT (r.id::varchar || 20021::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id 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, 0::numeric as settle_amount, r.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 NULL) AND ("r"."supplier_id"='431') )) "sub" ORDER BY created_at DESC LIMIT 40

[+] Explain
15:57:35.8850.4 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

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

[+] Explain
15:57:35.8870.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4

[+] Explain
15:57:35.8870.4 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

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

[+] Explain
15:57:35.8880.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4

[+] Explain
15:57:35.8890.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431

[+] Explain
15:57:35.8890.3 msSELECTSELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4498

[+] Explain
15:57:35.8901.1 msSELECTSELECT SUM(un_paid_amount) FROM ((SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id 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, 20020 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_payment_tickets" "r" WHERE ("r"."status"=2) AND ("r"."supplier_id"='431') AND (r.amount - r.settle_amount > 0)) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, r.contact_id as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, null::integer as 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, null::integer as t_type FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" WHERE ("r"."status"=2) AND ("r"."supplier_id"='431') AND (r.amount - r.settle_amount > 0) ) UNION ALL ( SELECT (r.id::varchar || 20021::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id 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, 0::numeric as settle_amount, r.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 NULL) AND ("r"."supplier_id"='431') )) "sub"

[+] Explain
15:57:35.8911.0 msSELECTSELECT COUNT(*) FROM ((SELECT (r.id::varchar || 20020::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id 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, 20020 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_payment_tickets" "r" WHERE ("r"."status"=2) AND ("r"."supplier_id"='431') AND (r.amount - r.settle_amount > 0)) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, r.contact_id as contact_id, null::integer as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, null::integer as 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, null::integer as t_type FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" WHERE ("r"."status"=2) AND ("r"."supplier_id"='431') AND (r.amount - r.settle_amount > 0) ) UNION ALL ( SELECT (r.id::varchar || 20021::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id 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, 0::numeric as settle_amount, r.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 NULL) AND ("r"."supplier_id"='431') )) "sub"

[+] Explain
15:57:35.8931.8 msINSERTINSERT 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-payment', '{"supplier_id":"431","page":"1","pageSize":"40","listReload":"true","web_access_token":"2SCKb3BYAaSLDxSx0sIX1KfVKBB-1lWj"}', '{"code":2000,"result":{"list":[{"id":61,"id2":61,"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-00005","ticket_type":20021,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"0.01","status":2,"settle_amount":"0","un_paid_amount":"0.01","is_payment_settle":false,"created_at":"2026-06-11 15:35:42","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":"0.01","count":1,"pagenation":{"totalcount":1,"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:35', 25159168) RETURNING "id"

[+] Explain