ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a1ea2e5350d4: POST https://beta.jinchangxiao.com/vue/search/purchase-contract-by-supplier-id at 2026-06-02 05:31:17 pm by 221.216.117.119

Database Queries

总计24条数据
TimeDurationTypeQuery
  
17:31:17.2190.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
17:31:17.2200.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
17:31:17.2210.6 msSELECTSELECT "id", "id" AS "key", "serial_no" AS "name", "created_at", "including_tax", "amount" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "supplier_id"='431' ORDER BY "signed_at" DESC

[+] Explain
17:31:17.2221.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (4487, 4485, 4482, 4477, 4474, 4475, 4471, 4472, 4470, 4473, 4466, 4465, 4451, 2364, 2216, 2198, 2114) ORDER BY "id"

[+] Explain
17:31:17.2231.5 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (14, 2120, 982, 1188)

[+] Explain
17:31:17.2251.3 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (2706, 4167, 2665)

[+] Explain
17:31:17.2261.5 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4487) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2280.5 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4485) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2280.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4482) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2290.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4477) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2300.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4474) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2300.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4475) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2310.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4471) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2310.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4472) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2320.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4470) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2320.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4473) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2330.5 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4466) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2330.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4465) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2340.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=4451) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2340.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=2364) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2350.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=2216) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2360.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=2198) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2360.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE ("contract_id"=2114) AND ((red_invoice_id is not null) OR ("is_cancel"=FALSE))

[+] Explain
17:31:17.2370.9 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/search/purchase-contract-by-supplier-id', '{"supplier_id":"431","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":[{"id":4487,"key":4487,"name":"\u6d4b\u8bd55555(2026-06-02)","created_at":"2026-06-02 17:01:19","including_tax":true,"amount":"55","purchaseClientRels":[],"invoiced":null,"un_invoiced":55},{"id":4485,"key":4485,"name":"\u4efb\u52a1\u800c\u4e3a(2026-06-01)","created_at":"2026-06-01 15:37:14","including_tax":true,"amount":"300","purchaseClientRels":[],"invoiced":null,"un_invoiced":300},{"id":4482,"key":4482,"name":"\u6d4b\u8bd5\u6284\u9001\u4eba\u63d0\u9192(2026-05-25)","created_at":"2026-05-25 17:23:38","including_tax":true,"amount":"88","purchaseClientRels":[],"invoiced":null,"un_invoiced":88},{"id":4477,"key":4477,"name":"\u65b9\u5f0f\u7b2c\u4e09\u65b9\u7684\u8eab\u4efd(2026-05-21)","created_at":"2026-05-21 17:21:08","including_tax":true,"amount":"1400","purchaseClientRels":[{"id":4811,"contract_id":4477,"client_id":1188,"project_id":2665,"client":{"id":1188,"key":1188,"name":"\u4e2d\u56fd\u7164\u70ad\u5730\u8d28\u603b\u5c40","sales_rep":1005},"project":{"id":2665,"key":2665,"name":"SD-WAN+\u529e\u516c\u7f51+\u5f02\u5730\u4e92\u8054"}}],"invoiced":null,"un_invoiced":1400},{"id":4474,"key":4474,"name":"8457384(2026-05-20)","created_at":"2026-05-20 17:17:55","including_tax":true,"amount":"70","purchaseClientRels":[],"invoiced":null,"un_invoiced":70},{"id":4475,"key":4475,"name":"\u7ecf\u624b\u4eba\u5173\u8054\u5ba2\u6237\u5546\u673a(2026-05-20)","created_at":"2026-05-20 17:19:24","including_tax":true,"amount":"888","purchaseClientRels":[{"id":4810,"contract_id":4475,"client_id":982,"project_id":4167,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","sales_rep":1001},"project":{"id":4167,"key":4167,"name":"\u65b0\u5efa\u9879\u76ee"}}],"invoiced":null,"un_invoiced":888},{"id":4471,"key":4471,"name":"\u672a\u8bbe\u7f6e(2026-05-15)","created_at":"2026-05-15 21:29:56","including_tax":true,"amount":"800","purchaseClientRels":[],"invoiced":null,"un_invoiced":800},{"id":4472,"key":4472,"name":"\u6d4b\u8bd5\u590d\u53e4\u98ce(2026-05-15)","created_at":"2026-05-15 21:34:44","including_tax":true,"amount":"100","purchaseClientRels":[],"invoiced":null,"un_invoiced":100},{"id":4470,"key":4470,"name":"\u6d4b\u7f51\u901f(2026-05-15)","created_at":"2026-05-15 21:29:33","including_tax":true,"amount":"2530","purchaseClientRels":[],"invoiced":null,"un_invoiced":2530},{"id":4473,"key":4473,"name":"\u672a\u8bbe\u7f6e(2026-05-15)","created_at":"2026-05-15 21:49:08","including_tax":true,"amount":"2222","purchaseClientRels":[],"invoiced":null,"un_invoiced":2222},{"id":4466,"key":4466,"name":"\u623f\u79df(2026-05-12)","created_at":"2026-05-12 14:20:03","including_tax":true,"amount":"100","purchaseClientRels":[],"invoiced":"100","un_invoiced":0},{"id":4465,"key":4465,"name":"\u6d4b\u8bd5\u6d4b\u8bd5(2026-05-12)","created_at":"2026-05-12 14:03:08","including_tax":true,"amount":"200","purchaseClientRels":[],"invoiced":null,"un_invoiced":200},{"id":4451,"key":4451,"name":"\u6d4b\u8bd5(2026-03-31)","created_at":"2026-03-31 17:32:35","including_tax":true,"amount":"1","purchaseClientRels":[],"invoiced":null,"un_invoiced":1},{"id":2364,"key":2364,"name":"BJHLXT-GFJ-20220610(2022-08-03)","created_at":"2022-08-03 10:59:27","including_tax":true,"amount":"4060.00","purchaseClientRels":[],"invoiced":"4060","un_invoiced":0},{"id":2216,"key":2216,"name":"20220211(2022-02-25)","created_at":"2022-02-25 15:17:24","including_tax":true,"amount":"1100.00","purchaseClientRels":[],"invoiced":"1100.00","un_invoiced":0},{"id":2198,"key":2198,"name":"BJHLXT-GFJ-2021207(2022-01-21)","created_at":"2022-01-21 09:26:04","including_tax":true,"amount":"63347.00","purchaseClientRels":[{"id":962,"contract_id":2198,"client_id":2120,"project_id":2706,"client":{"id":2120,"key":2120,"name":"\u8fbd\u5b81\u5e86\u9633\u7279\u79cd\u5316\u5de5\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1004},"project":{"id":2706,"key":2706,"name":"\u56fd\u4ea7\u5316\u6d4b\u8bd5\u673a"}}],"invoiced":"63347.00","un_invoiced":0},{"id":2114,"key":2114,"name":"BJHLXT-GFJ-20210928(2021-10-26)","created_at":"2021-10-26 11:38:52","including_tax":true,"amount":"116250.00","purchaseClientRels":[{"id":873,"contract_id":2114,"client_id":14,"project_id":null,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004},"project":null}],"invoiced":"116250.00","un_invoiced":0}],"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-02 17:31:17', 19709952) RETURNING "id"

[+] Explain