ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a56f8a6cea6b: POST https://beta.jinchangxiao.com/vue/erp-purchase-demand-statistics/list at 2026-07-15 11:04:06 am by 114.244.130.61

Database Queries

总计6条数据
TimeDurationTypeQuery
  
11:04:06.8500.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
11:04:06.8510.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
11:04:06.8530.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:04:06.85918.2 msSELECTSELECT COUNT(*) FROM (SELECT p.id as product_id, p.id as id, p.name as product_name, p.product_brand as product_brand_id, pb.name as product_brand_name, p.product_serie as product_serie_id, ps.name as product_serie_name, p.product_type as product_type_id, pt.name as product_type_name, p.product_component as product_component_id, pc.name as product_component_name, COALESCE(stock.available_stock_number, 0) as available_stock_number, COALESCE(purchase_un.purchase_order_un_inbound_number, 0) as purchase_order_un_inbound_number, COALESCE(sales_un.sales_order_un_outbound_number, 0) as sales_order_un_outbound_number, COALESCE(out_verify.outbound_verifying_number, 0) as outbound_verifying_number, COALESCE(in_verify.inbound_verifying_number, 0) as inbound_verifying_number, COALESCE(price.suggest_purchase_price, 0) as suggest_purchase_price FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON pb.id = p.product_brand LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON ps.id = p.product_serie LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON pt.id = p.product_type LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON pc.id = p.product_component LEFT JOIN (SELECT product_id, sum(inventory) as available_stock_number FROM "a57be577deb434"."tbl_erp_inventory_products" GROUP BY "product_id") "stock" ON stock.product_id = p.id LEFT JOIN (SELECT epop.product_id, sum(epop.number - COALESCE(epop.into_inventory, 0)) as purchase_order_un_inbound_number FROM "a57be577deb434"."tbl_erp_purchase_order_products" "epop" INNER JOIN "a57be577deb434"."tbl_erp_purchase_orders" "epo" ON epo.id = epop.erp_purchase_order_id WHERE (("epo"."status" IN (2, 5)) AND ("epo"."is_done"=FALSE)) AND (epop.number - COALESCE(epop.into_inventory, 0) <> 0) GROUP BY "epop"."product_id") "purchase_un" ON purchase_un.product_id = p.id LEFT JOIN (SELECT esop.product_id, sum(esop.number - COALESCE(esop.outbound, 0)) as sales_order_un_outbound_number FROM "a57be577deb434"."tbl_erp_sales_order_products" "esop" INNER JOIN "a57be577deb434"."tbl_erp_sales_orders" "eso" ON eso.id = esop.erp_sales_order_id WHERE (("eso"."status" IN (2, 5)) AND ("eso"."is_done"=FALSE)) AND (esop.number - COALESCE(esop.outbound, 0) <> 0) GROUP BY "esop"."product_id") "sales_un" ON sales_un.product_id = p.id LEFT JOIN (SELECT product_id, sum(outbound_verifying_number) as outbound_verifying_number FROM ((SELECT eip.product_id, sum(COALESCE(eips.outbound, 0)) as outbound_verifying_number FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eips" INNER JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.id = eips.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "eso" ON eso.id = eips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esg" ON esg.id = eips.erp_sales_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "eil" ON eil.id = eips.erp_inventory_lost_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eib.id = eips.erp_inventory_build_spent_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eid.id = eips.erp_inventory_disassemble_spent_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_transfers" "eit" ON eit.id = eips.erp_inventory_transfer_spent_id WHERE (("eips"."erp_sales_outbound_id" IS NOT NULL) AND ("eso"."status"=1)) OR (("eips"."erp_sales_gift_id" IS NOT NULL) AND ("esg"."status"=1)) OR (("eips"."erp_inventory_lost_id" IS NOT NULL) AND ("eil"."status"=1)) OR (("eips"."erp_inventory_build_spent_id" IS NOT NULL) AND ("eib"."status"=1)) OR (("eips"."erp_inventory_disassemble_spent_id" IS NOT NULL) AND ("eid"."status"=1)) OR (("eips"."erp_inventory_transfer_spent_id" IS NOT NULL) AND ("eit"."status"=1)) GROUP BY "eip"."product_id") UNION ALL ( SELECT eprp.product_id, sum(eprp.number) as outbound_verifying_number FROM "a57be577deb434"."tbl_erp_purchase_return_products" "eprp" INNER JOIN "a57be577deb434"."tbl_erp_purchase_returns" "epr" ON epr.id = eprp.erp_purchase_return_id WHERE "epr"."status"=1 GROUP BY "eprp"."product_id" )) "outbound_detail" GROUP BY "product_id") "out_verify" ON out_verify.product_id = p.id LEFT JOIN (SELECT product_id, sum(number) as inbound_verifying_number FROM ((SELECT epip.product_id, sum(epip.number - COALESCE(epip.cancel_number, 0)) as number FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" "epip" INNER JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epi" ON epi.id = epip.erp_purchase_inbound_id WHERE "epi"."status"=1 GROUP BY "epip"."product_id") UNION ALL ( SELECT epgp.product_id, sum(epgp.number - COALESCE(epgp.cancel_number, 0)) as number FROM "a57be577deb434"."tbl_erp_purchase_gift_products" "epgp" INNER JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epg" ON epg.id = epgp.erp_purchase_gift_id WHERE "epg"."status"=1 GROUP BY "epgp"."product_id" ) UNION ALL ( SELECT eiop.product_id, sum(eiop.number - COALESCE(eiop.cancel_number, 0)) as number FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" "eiop" INNER JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eio" ON eio.id = eiop.erp_inventory_overflow_id WHERE "eio"."status"=1 GROUP BY "eiop"."product_id" ) UNION ALL ( SELECT eibp.product_id, sum(eibp.number) as number FROM "a57be577deb434"."tbl_erp_inventory_build_products" "eibp" INNER JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eib.id = eibp.erp_inventory_build_id WHERE "eib"."status"=1 GROUP BY "eibp"."product_id" ) UNION ALL ( SELECT eidp.product_id, sum(eidp.number) as number FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" "eidp" INNER JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eid.id = eidp.erp_inventory_disassemble_id WHERE "eid"."status"=1 GROUP BY "eidp"."product_id" ) UNION ALL ( SELECT eitp.product_id, sum(eitp.number) as number FROM "a57be577deb434"."tbl_erp_inventory_transfer_products" "eitp" INNER JOIN "a57be577deb434"."tbl_erp_inventory_transfers" "eit" ON eit.id = eitp.erp_inventory_transfer_id WHERE "eit"."status"=1 GROUP BY "eitp"."product_id" ) UNION ALL ( SELECT esrp.product_id, sum(esrp.number) as number FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrp" INNER JOIN "a57be577deb434"."tbl_erp_sales_returns" "esr" ON esr.id = esrp.erp_sales_return_id WHERE "esr"."status"=1 GROUP BY "esrp"."product_id" )) "inbound_detail" GROUP BY "product_id") "in_verify" ON in_verify.product_id = p.id LEFT JOIN (SELECT product_id, avg(CASE WHEN actual_amount IS NOT NULL THEN actual_amount ELSE amount END) as suggest_purchase_price FROM "a57be577deb434"."tbl_erp_inventory_products" GROUP BY "product_id") "price" ON price.product_id = p.id WHERE ( COALESCE(stock.available_stock_number, 0) <> 0 OR COALESCE(purchase_un.purchase_order_un_inbound_number, 0) <> 0 OR COALESCE(sales_un.sales_order_un_outbound_number, 0) <> 0 OR COALESCE(out_verify.outbound_verifying_number, 0) <> 0 OR COALESCE(in_verify.inbound_verifying_number, 0) <> 0 ) AND ("p"."id"='1372') ORDER BY p.updated_at DESC nulls last, p.id DESC) "c"

[+] Explain
11:04:06.87812.9 msSELECTSELECT p.id as product_id, p.id as id, p.name as product_name, p.product_brand as product_brand_id, pb.name as product_brand_name, p.product_serie as product_serie_id, ps.name as product_serie_name, p.product_type as product_type_id, pt.name as product_type_name, p.product_component as product_component_id, pc.name as product_component_name, COALESCE(stock.available_stock_number, 0) as available_stock_number, COALESCE(purchase_un.purchase_order_un_inbound_number, 0) as purchase_order_un_inbound_number, COALESCE(sales_un.sales_order_un_outbound_number, 0) as sales_order_un_outbound_number, COALESCE(out_verify.outbound_verifying_number, 0) as outbound_verifying_number, COALESCE(in_verify.inbound_verifying_number, 0) as inbound_verifying_number, COALESCE(price.suggest_purchase_price, 0) as suggest_purchase_price FROM "a57be577deb434"."tbl_products" "p" LEFT JOIN "a57be577deb434"."tbl_product_brands" "pb" ON pb.id = p.product_brand LEFT JOIN "a57be577deb434"."tbl_product_series" "ps" ON ps.id = p.product_serie LEFT JOIN "a57be577deb434"."tbl_product_types" "pt" ON pt.id = p.product_type LEFT JOIN "a57be577deb434"."tbl_product_components" "pc" ON pc.id = p.product_component LEFT JOIN (SELECT product_id, sum(inventory) as available_stock_number FROM "a57be577deb434"."tbl_erp_inventory_products" GROUP BY "product_id") "stock" ON stock.product_id = p.id LEFT JOIN (SELECT epop.product_id, sum(epop.number - COALESCE(epop.into_inventory, 0)) as purchase_order_un_inbound_number FROM "a57be577deb434"."tbl_erp_purchase_order_products" "epop" INNER JOIN "a57be577deb434"."tbl_erp_purchase_orders" "epo" ON epo.id = epop.erp_purchase_order_id WHERE (("epo"."status" IN (2, 5)) AND ("epo"."is_done"=FALSE)) AND (epop.number - COALESCE(epop.into_inventory, 0) <> 0) GROUP BY "epop"."product_id") "purchase_un" ON purchase_un.product_id = p.id LEFT JOIN (SELECT esop.product_id, sum(esop.number - COALESCE(esop.outbound, 0)) as sales_order_un_outbound_number FROM "a57be577deb434"."tbl_erp_sales_order_products" "esop" INNER JOIN "a57be577deb434"."tbl_erp_sales_orders" "eso" ON eso.id = esop.erp_sales_order_id WHERE (("eso"."status" IN (2, 5)) AND ("eso"."is_done"=FALSE)) AND (esop.number - COALESCE(esop.outbound, 0) <> 0) GROUP BY "esop"."product_id") "sales_un" ON sales_un.product_id = p.id LEFT JOIN (SELECT product_id, sum(outbound_verifying_number) as outbound_verifying_number FROM ((SELECT eip.product_id, sum(COALESCE(eips.outbound, 0)) as outbound_verifying_number FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eips" INNER JOIN "a57be577deb434"."tbl_erp_inventory_products" "eip" ON eip.id = eips.erp_inventory_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "eso" ON eso.id = eips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "esg" ON esg.id = eips.erp_sales_gift_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_losts" "eil" ON eil.id = eips.erp_inventory_lost_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eib.id = eips.erp_inventory_build_spent_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eid.id = eips.erp_inventory_disassemble_spent_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_transfers" "eit" ON eit.id = eips.erp_inventory_transfer_spent_id WHERE (("eips"."erp_sales_outbound_id" IS NOT NULL) AND ("eso"."status"=1)) OR (("eips"."erp_sales_gift_id" IS NOT NULL) AND ("esg"."status"=1)) OR (("eips"."erp_inventory_lost_id" IS NOT NULL) AND ("eil"."status"=1)) OR (("eips"."erp_inventory_build_spent_id" IS NOT NULL) AND ("eib"."status"=1)) OR (("eips"."erp_inventory_disassemble_spent_id" IS NOT NULL) AND ("eid"."status"=1)) OR (("eips"."erp_inventory_transfer_spent_id" IS NOT NULL) AND ("eit"."status"=1)) GROUP BY "eip"."product_id") UNION ALL ( SELECT eprp.product_id, sum(eprp.number) as outbound_verifying_number FROM "a57be577deb434"."tbl_erp_purchase_return_products" "eprp" INNER JOIN "a57be577deb434"."tbl_erp_purchase_returns" "epr" ON epr.id = eprp.erp_purchase_return_id WHERE "epr"."status"=1 GROUP BY "eprp"."product_id" )) "outbound_detail" GROUP BY "product_id") "out_verify" ON out_verify.product_id = p.id LEFT JOIN (SELECT product_id, sum(number) as inbound_verifying_number FROM ((SELECT epip.product_id, sum(epip.number - COALESCE(epip.cancel_number, 0)) as number FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" "epip" INNER JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "epi" ON epi.id = epip.erp_purchase_inbound_id WHERE "epi"."status"=1 GROUP BY "epip"."product_id") UNION ALL ( SELECT epgp.product_id, sum(epgp.number - COALESCE(epgp.cancel_number, 0)) as number FROM "a57be577deb434"."tbl_erp_purchase_gift_products" "epgp" INNER JOIN "a57be577deb434"."tbl_erp_purchase_gifts" "epg" ON epg.id = epgp.erp_purchase_gift_id WHERE "epg"."status"=1 GROUP BY "epgp"."product_id" ) UNION ALL ( SELECT eiop.product_id, sum(eiop.number - COALESCE(eiop.cancel_number, 0)) as number FROM "a57be577deb434"."tbl_erp_inventory_overflow_products" "eiop" INNER JOIN "a57be577deb434"."tbl_erp_inventory_overflows" "eio" ON eio.id = eiop.erp_inventory_overflow_id WHERE "eio"."status"=1 GROUP BY "eiop"."product_id" ) UNION ALL ( SELECT eibp.product_id, sum(eibp.number) as number FROM "a57be577deb434"."tbl_erp_inventory_build_products" "eibp" INNER JOIN "a57be577deb434"."tbl_erp_inventory_builds" "eib" ON eib.id = eibp.erp_inventory_build_id WHERE "eib"."status"=1 GROUP BY "eibp"."product_id" ) UNION ALL ( SELECT eidp.product_id, sum(eidp.number) as number FROM "a57be577deb434"."tbl_erp_inventory_disassemble_products" "eidp" INNER JOIN "a57be577deb434"."tbl_erp_inventory_disassembles" "eid" ON eid.id = eidp.erp_inventory_disassemble_id WHERE "eid"."status"=1 GROUP BY "eidp"."product_id" ) UNION ALL ( SELECT eitp.product_id, sum(eitp.number) as number FROM "a57be577deb434"."tbl_erp_inventory_transfer_products" "eitp" INNER JOIN "a57be577deb434"."tbl_erp_inventory_transfers" "eit" ON eit.id = eitp.erp_inventory_transfer_id WHERE "eit"."status"=1 GROUP BY "eitp"."product_id" ) UNION ALL ( SELECT esrp.product_id, sum(esrp.number) as number FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrp" INNER JOIN "a57be577deb434"."tbl_erp_sales_returns" "esr" ON esr.id = esrp.erp_sales_return_id WHERE "esr"."status"=1 GROUP BY "esrp"."product_id" )) "inbound_detail" GROUP BY "product_id") "in_verify" ON in_verify.product_id = p.id LEFT JOIN (SELECT product_id, avg(CASE WHEN actual_amount IS NOT NULL THEN actual_amount ELSE amount END) as suggest_purchase_price FROM "a57be577deb434"."tbl_erp_inventory_products" GROUP BY "product_id") "price" ON price.product_id = p.id WHERE ( COALESCE(stock.available_stock_number, 0) <> 0 OR COALESCE(purchase_un.purchase_order_un_inbound_number, 0) <> 0 OR COALESCE(sales_un.sales_order_un_outbound_number, 0) <> 0 OR COALESCE(out_verify.outbound_verifying_number, 0) <> 0 OR COALESCE(in_verify.inbound_verifying_number, 0) <> 0 ) AND ("p"."id"='1372') ORDER BY p.updated_at DESC nulls last, p.id DESC LIMIT 20

[+] Explain
11:04:06.8921.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-purchase-demand-statistics/list', '{"product_id":"1372","product_brand":"","product_serie":"","product_type":"","product_component":"","keyword":"","page":"1","web_access_token":"wDahkMIsEuHhAvKCnlYJe0vzWaI3UM9g"}', '{"code":2000,"result":{"list":[{"product_id":1372,"id":1372,"product_name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_brand_id":134,"product_brand_name":"\u7b2c\u4e09\u65b9","product_serie_id":1047,"product_serie_name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73","product_type_id":4,"product_type_name":"\u7f51\u7edc\u8bbe\u5907 ","product_component_id":43,"product_component_name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6","available_stock_number":"14","purchase_order_un_inbound_number":"50","sales_order_un_outbound_number":"0","outbound_verifying_number":"0","inbound_verifying_number":"0","suggest_purchase_price":19,"stock_number":14,"purchase_demand_number":-64,"suggest_purchase_amount":-1216,"product":{"id":1372,"key":1372,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":1047,"key":1047,"name":"LC-LC \u5149\u7ea4\u7ebf 5\u7c73"},"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"}}],"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.61","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-15 11:04:06', 45108992) RETURNING "id"

[+] Explain