ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68a43994ee22c: POST https://beta.jinchangxiao.com/vue/tax/sales-invoice-list-match at 2025-08-19 04:45:08 pm by 223.104.44.8

Database Queries

总计25条数据
TimeDurationTypeQuery
  
16:45:08.9782.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
16:45:08.9821.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:45:08.9853.6 msSELECTSELECT COUNT(*) FROM (SELECT ip.* FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id" ORDER BY "ip"."created_at" DESC) "c"

[+] Explain
16:45:08.9891.9 msSELECTSELECT ip.* FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id" ORDER BY "ip"."created_at" DESC LIMIT 20

[+] Explain
16:45:08.9910.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id" IN (2387, 2386)

[+] Explain
16:45:08.9920.3 msSELECTSELECT "id", "id" AS "key", "serial_no", "supplier_id" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4045, 4052)

[+] Explain
16:45:08.9920.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=608

[+] Explain
16:45:08.9930.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=608

[+] Explain
16:45:08.9930.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_invoice_projects" WHERE "purchase_invoice_id" IN (2386, 2387)

[+] Explain
16:45:08.9930.3 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3920, 3925, 3924)

[+] Explain
16:45:08.9940.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=12

[+] Explain
16:45:08.9940.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_invoice_reminders" WHERE "purchase_invoice_id" IN (2386, 2387)

[+] Explain
16:45:08.9940.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5360

[+] Explain
16:45:08.9950.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_invoice_products" WHERE "purchase_invoice_id" IN (2386, 2387)

[+] Explain
16:45:08.9951.8 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")

[+] Explain
16:45:08.9971.9 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")

[+] Explain
16:45:08.9992.1 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_inventory_products" WHERE ("id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")) AND (outbound > 0)

[+] Explain
16:45:09.0021.8 msSELECTSELECT SUM(amount / number * outbound) FROM "a57be577deb434"."tbl_inventory_products" WHERE ("id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")) AND (outbound > 0)

[+] Explain
16:45:09.0041.7 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_inventory_products" WHERE ("id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")) AND (inventory > 0)

[+] Explain
16:45:09.0051.7 msSELECTSELECT SUM(amount / number * inventory) FROM "a57be577deb434"."tbl_inventory_products" WHERE ("id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")) AND (inventory > 0)

[+] Explain
16:45:09.0071.7 msSELECTSELECT SUM(excluding_tax) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")

[+] Explain
16:45:09.0091.7 msSELECTSELECT SUM(tax_amount) FROM "a57be577deb434"."tbl_inventory_products" WHERE "id" IN (SELECT "ip"."id" FROM "a57be577deb434"."tbl_inventory_products" "ip" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "pci" ON ip.purchase_invoice_id = pci.id LEFT JOIN "a57be577deb434"."tbl_purchase_contracts" "pc" ON pc.id = pci.contract_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON pc.supplier_id = s.id LEFT JOIN "a57be577deb434"."tbl_purchase_invoice_projects" "pip" ON pci.id = pip.purchase_invoice_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = pip.project_id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE (LOWER(ip.description) = LOWER('*计算机配套产品*内存')) AND (LOWER(ip.title) = LOWER('16g')) AND ("ip"."inventory" > 0) GROUP BY "ip"."id", "pci"."id")

[+] Explain
16:45:09.0133.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=10004) AND ("visit_date"='2025-08-19')

[+] Explain
16:45:09.0171.0 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=109, "last_visit_at"='now()' WHERE "id"=55336

[+] Explain
16:45:09.0181.3 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/tax/sales-invoice-list-match', '{"InventoryProductSearch":{"is_verify":"","is_build":"","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","title":"16G","id":"2116"},"page":"1","web_access_token":"239qcuu_ToIhJtTt60gp-9_fllLTtTgq"}', '{"code":2000,"result":{"list":[{"id":1830,"purchase_invoice_id":2387,"purchase_product_id":1914,"title":"16g","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"2","unit":"\u6761","outbound":"0","inventory":"2","amount":"398.63","tax_rate":"1","including_tax":"0","excluding_tax":"394.68","tax_amount":"3.95","is_build":false,"build_group_id":"","created_at":"2025-08-04 11:52:07","purchaseInvoice":{"id":2387,"contract_id":4052,"amount":"398.63","attachment_id":"","from_date":"2025-08-01","created_by":5360,"created_at":"2025-08-04 11:50:15","description":"","invoice_num":"25342000000131931366","invoice_type":2,"handler":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":3.95,"excluding_tax":394.68,"verify_at":"","is_used":false,"updated_at":"2025-08-04 11:52:07","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":608,"is_contract_cancel":false,"contract":{"id":4052,"key":4052,"serial_no":"\u8ba2\u5355\u53f7: 4643512058994592710\/4643515981688592710","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseInvoiceProjects":[{"id":2416,"purchase_invoice_id":2387,"project_id":3925,"project":{"id":3925,"key":3925,"name":"OTJ25076289-\u5185\u5b58\u6761-G-2025","client_id":12,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}}},{"id":2417,"purchase_invoice_id":2387,"project_id":3924,"project":{"id":3924,"key":3924,"name":"OTJ25076163-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1914,"purchase_invoice_id":2387,"title":"16g","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"2","outbound":"0","inventory":"2","unit":"\u6761","amount":"398.63","tax_rate":"1","including_tax":"0","excluding_tax":"394.68","tax_amount":"3.95","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":2,"un_used_amount":398.63,"tax_rate":["1"]}},{"id":1829,"purchase_invoice_id":2386,"purchase_product_id":1913,"title":"16g","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"1","unit":"\u6761","outbound":"0","inventory":"1","amount":"197.75","tax_rate":"1","including_tax":"0","excluding_tax":"195.79","tax_amount":"1.96","is_build":false,"build_group_id":"","created_at":"2025-08-04 11:51:20","purchaseInvoice":{"id":2386,"contract_id":4045,"amount":"197.75","attachment_id":"","from_date":"2025-08-01","created_by":5360,"created_at":"2025-08-04 11:49:56","description":"","invoice_num":"25342000000131894984","invoice_type":2,"handler":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3},"is_verify":false,"is_cancel":false,"paid_amount":"0","tax_amount":1.96,"excluding_tax":195.79,"verify_at":"","is_used":false,"updated_at":"2025-08-04 11:51:20","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":false,"supplier_id":608,"is_contract_cancel":false,"contract":{"id":4045,"key":4045,"serial_no":"\u8ba2\u5355\u53f7: 4635961815999592710","supplier_id":608,"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"}},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseInvoiceProjects":[{"id":2415,"purchase_invoice_id":2386,"project_id":3920,"project":{"id":3920,"key":3920,"name":"OTJ25075740-\u5185\u5b58-2025","client_id":12,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}}}],"purchaseInvoiceReminders":[],"purchaseInvoiceProducts":[{"id":1913,"purchase_invoice_id":2386,"title":"16g","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"1","outbound":"0","inventory":"1","unit":"\u6761","amount":"197.75","tax_rate":"1","including_tax":"0","excluding_tax":"195.79","tax_amount":"1.96","into_inventory":true}],"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"un_used_amount":197.75,"tax_rate":["1"]}}],"can_create":true,"count":{"count":2,"amount":"596.38","outbound_count":0,"outbound_amount":0,"inventory_count":2,"inventory_amount":"596.3800000000000000","excluding_tax":"590.47","tax_amount":"5.91"},"pagenation":{"totalcount":2,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-19 16:45:09') RETURNING "id"

[+] Explain