ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a572ae4a5d5d: POST https://beta.jinchangxiao.com/vue/erp-purchase-demand-statistics/list at 2026-07-15 02:38:28 pm by 114.244.130.61

Performance Profiling

Total processing time: 58 ms; Peak memory: 4.128 MB. Show Profiling Timeline

总计7条数据
TimeDurationCategoryInfo
  
14:38:28.70721.5 msyii\db\Command::querySELECT 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 ORDER BY p.updated_at DESC nulls last, p.id DESC LIMIT 20
14:38:28.69114.9 msyii\db\Command::querySELECT 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 ORDER BY p.updated_at DESC nulls last, p.id DESC) "c"
14:38:28.7312.0 msyii\db\Command::queryINSERT 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":"","product_brand":"","product_serie":"","product_type":"","product_component":"","keyword":"","page":"1","web_access_token":"wDahkMIsEuHhAvKCnlYJe0vzWaI3UM9g"}', '{"code":2000,"result":{"list":[{"product_id":2267,"id":2267,"product_name":"\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681","product_brand_id":287,"product_brand_name":"\u98de\u5229\u6d66","product_serie_id":1784,"product_serie_name":"\u7535\u52a8\u7259\u5237","product_type_id":23,"product_type_name":"\u793c\u54c1","product_component_id":221,"product_component_name":"\u7535\u5b50\u4ea7\u54c1","available_stock_number":"100","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"2","outbound_verifying_number":"0","inbound_verifying_number":"0","suggest_purchase_price":282.53,"stock_number":100,"purchase_demand_number":-98,"suggest_purchase_amount":-27687.56,"product":{"id":2267,"key":2267,"name":"\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681"},"productBrand":{"id":287,"key":287,"name":"\u98de\u5229\u6d66"},"productSerie":{"id":1784,"key":1784,"name":"\u7535\u52a8\u7259\u5237"},"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":221,"key":221,"name":"\u7535\u5b50\u4ea7\u54c1"}},{"product_id":2171,"id":2171,"product_name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1","product_brand_id":270,"product_brand_name":"\u91d1\u7545\u900d","product_serie_id":1724,"product_serie_name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6","product_type_id":7,"product_type_name":"\u8f6f\u4ef6","product_component_id":159,"product_component_name":"\u529e\u516c\u8f6f\u4ef6","available_stock_number":"100","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"13","outbound_verifying_number":"0","inbound_verifying_number":"0","suggest_purchase_price":257.29,"stock_number":100,"purchase_demand_number":-87,"suggest_purchase_amount":-22383.86,"product":{"id":2171,"key":2171,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1"},"productBrand":{"id":270,"key":270,"name":"\u91d1\u7545\u900d"},"productSerie":{"id":1724,"key":1724,"name":"\u91d1\u7545\u900dCRM\u8f6f\u4ef6"},"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":159,"key":159,"name":"\u529e\u516c\u8f6f\u4ef6"}},{"product_id":2261,"id":2261,"product_name":"MK-MC300","product_brand_id":4,"product_brand_name":"\u8054\u60f3","product_serie_id":1769,"product_serie_name":"\u5168\u5411\u9ea6\u514b\u98ce","product_type_id":4,"product_type_name":"\u7f51\u7edc\u8bbe\u5907 ","product_component_id":52,"product_component_name":"\u534f\u4f5c","available_stock_number":"145","purchase_order_un_inbound_number":"11","sales_order_un_outbound_number":"28","outbound_verifying_number":"4","inbound_verifying_number":"3","suggest_purchase_price":3787.68,"stock_number":149,"purchase_demand_number":-127,"suggest_purchase_amount":-481034.91,"product":{"id":2261,"key":2261,"name":"MK-MC300"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1769,"key":1769,"name":"\u5168\u5411\u9ea6\u514b\u98ce"},"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":52,"key":52,"name":"\u534f\u4f5c"}},{"product_id":2177,"id":2177,"product_name":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0","product_brand_id":12,"product_brand_name":"\u6df1\u4fe1\u670d","product_serie_id":1730,"product_serie_name":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0","product_type_id":7,"product_type_name":"\u8f6f\u4ef6","product_component_id":139,"product_component_name":"\u8d85\u878d\u5408\u8f6f\u4ef6","available_stock_number":"2","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"17","outbound_verifying_number":"2","inbound_verifying_number":"2","suggest_purchase_price":25798.6,"stock_number":4,"purchase_demand_number":15,"suggest_purchase_amount":386979,"product":{"id":2177,"key":2177,"name":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0"},"productBrand":{"id":12,"key":12,"name":"\u6df1\u4fe1\u670d"},"productSerie":{"id":1730,"key":1730,"name":"\u6df1\u4fe1\u670dSDDC\u57fa\u7840\u8fd0\u7ef4\u8f6f\u4ef6V1.0"},"productType":{"id":7,"key":7,"name":"\u8f6f\u4ef6"},"productComponent":{"id":139,"key":139,"name":"\u8d85\u878d\u5408\u8f6f\u4ef6"}},{"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":"2","outbound_verifying_number":"0","inbound_verifying_number":"0","suggest_purchase_price":19,"stock_number":14,"purchase_demand_number":-62,"suggest_purchase_amount":-1178,"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"}},{"product_id":1025,"id":1025,"product_name":"FOC-1010","product_brand_id":152,"product_brand_name":"\u80dc\u4e3a","product_serie_id":714,"product_serie_name":"\u4e07\u5146\u591a\u6a21\u5149\u7ea4\u8df3\u7ebfLC-LC 1\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":"2","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"0","outbound_verifying_number":"0","inbound_verifying_number":"0","suggest_purchase_price":10,"stock_number":2,"purchase_demand_number":-2,"suggest_purchase_amount":-20,"product":{"id":1025,"key":1025,"name":"FOC-1010"},"productBrand":{"id":152,"key":152,"name":"\u80dc\u4e3a"},"productSerie":{"id":714,"key":714,"name":"\u4e07\u5146\u591a\u6a21\u5149\u7ea4\u8df3\u7ebfLC-LC 1\u7c73"},"productType":{"id":4,"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},"productComponent":{"id":43,"key":43,"name":"\u7f51\u7edc\u8bbe\u5907\u914d\u4ef6"}},{"product_id":2265,"id":2265,"product_name":"\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2","product_brand_id":284,"product_brand_name":"\u6b27\u4e3d\u8587\u5170","product_serie_id":1775,"product_serie_name":"\u98df\u7528\u6cb9","product_type_id":23,"product_type_name":"\u793c\u54c1","product_component_id":195,"product_component_name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865","available_stock_number":"11","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"1","outbound_verifying_number":"0","inbound_verifying_number":"0","suggest_purchase_price":6133.32,"stock_number":11,"purchase_demand_number":-10,"suggest_purchase_amount":-61333.17,"product":{"id":2265,"key":2265,"name":"\u6b27\u4e3d\u8587\u5170Olivoila \u6a44\u6984\u6cb9500MLx2 \u7cbe\u9009\u793c\u76d2"},"productBrand":{"id":284,"key":284,"name":"\u6b27\u4e3d\u8587\u5170"},"productSerie":{"id":1775,"key":1775,"name":"\u98df\u7528\u6cb9"},"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"}},{"product_id":2232,"id":2232,"product_name":"PAN-SVC-BKLN-3440-3YR","product_brand_id":8,"product_brand_name":"PaloAlto","product_serie_id":1760,"product_serie_name":"\u4e09\u5e74\u670d\u52a1","product_type_id":5,"product_type_name":"\u5b89\u5168\u8bbe\u5907","product_component_id":214,"product_component_name":"\u9632\u706b\u5899\u670d\u52a1","available_stock_number":"39","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"0","outbound_verifying_number":"16","inbound_verifying_number":"0","suggest_purchase_price":64139,"stock_number":55,"purchase_demand_number":-23,"suggest_purchase_amount":-1475197,"product":{"id":2232,"key":2232,"name":"PAN-SVC-BKLN-3440-3YR"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1760,"key":1760,"name":"\u4e09\u5e74\u670d\u52a1"},"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":214,"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1"}},{"product_id":2231,"id":2231,"product_name":"PAN-PA-3440-ATP-3YR","product_brand_id":8,"product_brand_name":"PaloAlto","product_serie_id":1759,"product_serie_name":"PA3440\u8f6f\u4ef6\u6388\u6743","product_type_id":5,"product_type_name":"\u5b89\u5168\u8bbe\u5907","product_component_id":36,"product_component_name":"PA\u8bb8\u53ef\u8bc1","available_stock_number":"121","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"0","outbound_verifying_number":"0","inbound_verifying_number":"0","suggest_purchase_price":81196,"stock_number":121,"purchase_demand_number":-121,"suggest_purchase_amount":-9824716,"product":{"id":2231,"key":2231,"name":"PAN-PA-3440-ATP-3YR"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1759,"key":1759,"name":"PA3440\u8f6f\u4ef6\u6388\u6743"},"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"}},{"product_id":1558,"id":1558,"product_name":"PAN-PA-1420","product_brand_id":8,"product_brand_name":"PaloAlto","product_serie_id":1344,"product_serie_name":"PA-1420\u9632\u706b\u5899\u4e3b\u673a","product_type_id":5,"product_type_name":"\u5b89\u5168\u8bbe\u5907","product_component_id":26,"product_component_name":"\u9632\u706b\u5899\u4e3b\u673a","available_stock_number":"124","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"0","outbound_verifying_number":"0","inbound_verifying_number":"0","suggest_purchase_price":19849.78,"stock_number":124,"purchase_demand_number":-124,"suggest_purchase_amount":-2461372.1,"product":{"id":1558,"key":1558,"name":"PAN-PA-1420"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1344,"key":1344,"name":"PA-1420\u9632\u706b\u5899\u4e3b\u673a"},"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"}},{"product_id":989,"id":989,"product_name":"PAN-PA-400-RACKTRAY","product_brand_id":8,"product_brand_name":"PaloAlto","product_serie_id":615,"product_serie_name":"PA-440\/450\/460\u5bfc\u8f68","product_type_id":5,"product_type_name":"\u5b89\u5168\u8bbe\u5907","product_component_id":157,"product_component_name":"\u9632\u706b\u5899\u914d\u4ef6","available_stock_number":"71","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"0","outbound_verifying_number":"0","inbound_verifying_number":"0","suggest_purchase_price":577,"stock_number":71,"purchase_demand_number":-71,"suggest_purchase_amount":-40967,"product":{"id":989,"key":989,"name":"PAN-PA-400-RACKTRAY"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":615,"key":615,"name":"PA-440\/450\/460\u5bfc\u8f68"},"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"}},{"product_id":969,"id":969,"product_name":"PAN-PA-1410","product_brand_id":8,"product_brand_name":"PaloAlto","product_serie_id":607,"product_serie_name":"PA-1410\u9632\u706b\u5899\u4e3b\u673a","product_type_id":5,"product_type_name":"\u5b89\u5168\u8bbe\u5907","product_component_id":26,"product_component_name":"\u9632\u706b\u5899\u4e3b\u673a","available_stock_number":"121","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"0","outbound_verifying_number":"0","inbound_verifying_number":"2","suggest_purchase_price":12226.67,"stock_number":121,"purchase_demand_number":-123,"suggest_purchase_amount":-1503880,"product":{"id":969,"key":969,"name":"PAN-PA-1410"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":607,"key":607,"name":"PA-1410\u9632\u706b\u5899\u4e3b\u673a"},"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":26,"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a"}},{"product_id":870,"id":870,"product_name":"LIS-F1000-AK-AV-1Y","product_brand_id":20,"product_brand_name":"H3C","product_serie_id":551,"product_serie_name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License","product_type_id":5,"product_type_name":"\u5b89\u5168\u8bbe\u5907","product_component_id":35,"product_component_name":"\u9632\u706b\u5899\u8f6f\u4ef6","available_stock_number":"104","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"0","outbound_verifying_number":"17","inbound_verifying_number":"0","suggest_purchase_price":291.33,"stock_number":121,"purchase_demand_number":-87,"suggest_purchase_amount":-25346,"product":{"id":870,"key":870,"name":"LIS-F1000-AK-AV-1Y"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":551,"key":551,"name":"H3C SecPath F1000-AK,AV \u9632\u75c5\u6bd2\u5b89\u5168License"},"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"}},{"product_id":868,"id":868,"product_name":"LIS-F1000-AK-URL-1Y","product_brand_id":20,"product_brand_name":"H3C","product_serie_id":1223,"product_serie_name":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd","product_type_id":5,"product_type_name":"\u5b89\u5168\u8bbe\u5907","product_component_id":35,"product_component_name":"\u9632\u706b\u5899\u8f6f\u4ef6","available_stock_number":"713","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"0","outbound_verifying_number":"9","inbound_verifying_number":"0","suggest_purchase_price":178.25,"stock_number":722,"purchase_demand_number":-704,"suggest_purchase_amount":-125488,"product":{"id":868,"key":868,"name":"LIS-F1000-AK-URL-1Y"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1223,"key":1223,"name":"H3C SecPath F1000-AK URL\u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1\u6388\u6743\u51fd"},"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"}},{"product_id":867,"id":867,"product_name":"LIS-F1000-AK-IPS-1Y","product_brand_id":20,"product_brand_name":"H3C","product_serie_id":1222,"product_serie_name":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1","product_type_id":5,"product_type_name":"\u5b89\u5168\u8bbe\u5907","product_component_id":35,"product_component_name":"\u9632\u706b\u5899\u8f6f\u4ef6","available_stock_number":"121","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"0","outbound_verifying_number":"0","inbound_verifying_number":"1","suggest_purchase_price":259,"stock_number":121,"purchase_demand_number":-122,"suggest_purchase_amount":-31598,"product":{"id":867,"key":867,"name":"LIS-F1000-AK-IPS-1Y"},"productBrand":{"id":20,"key":20,"name":"H3C"},"productSerie":{"id":1222,"key":1222,"name":"H3C SecPath F1000-AK,IPS \u7279\u5f81\u5e93\u5347\u7ea7\u670d\u52a1"},"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"}},{"product_id":2269,"id":2269,"product_name":"HAT5320-24T","product_brand_id":27,"product_brand_name":"\u7fa4\u6656","product_serie_id":1786,"product_serie_name":"HAT5300 \u7cfb\u5217\u786c\u76d8","product_type_id":3,"product_type_name":"\u5b58\u50a8\u8bbe\u5907","product_component_id":15,"product_component_name":"\u5b58\u50a8\u786c\u76d8","available_stock_number":"5","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"8","outbound_verifying_number":"10","inbound_verifying_number":"7","suggest_purchase_price":3915.4,"stock_number":15,"purchase_demand_number":6,"suggest_purchase_amount":23492.4,"product":{"id":2269,"key":2269,"name":"HAT5320-24T"},"productBrand":{"id":27,"key":27,"name":"\u7fa4\u6656"},"productSerie":{"id":1786,"key":1786,"name":"HAT5300 \u7cfb\u5217\u786c\u76d8"},"productType":{"id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},"productComponent":{"id":15,"key":15,"name":"\u5b58\u50a8\u786c\u76d8"}},{"product_id":1562,"id":1562,"product_name":"PAN-PWR-450W-AC","product_brand_id":8,"product_brand_name":"PaloAlto","product_serie_id":1244,"product_serie_name":"PA1420\u8f6f\u4ef6\u6388\u6743","product_type_id":5,"product_type_name":"\u5b89\u5168\u8bbe\u5907","product_component_id":36,"product_component_name":"PA\u8bb8\u53ef\u8bc1","available_stock_number":"2","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"3","outbound_verifying_number":"0","inbound_verifying_number":"0","suggest_purchase_price":9606.93,"stock_number":2,"purchase_demand_number":1,"suggest_purchase_amount":9606.93,"product":{"id":1562,"key":1562,"name":"PAN-PWR-450W-AC"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1244,"key":1244,"name":"PA1420\u8f6f\u4ef6\u6388\u6743"},"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":36,"key":36,"name":"PA\u8bb8\u53ef\u8bc1"}},{"product_id":2262,"id":2262,"product_name":"PAN-SFP-PLUS-SR","product_brand_id":8,"product_brand_name":"PaloAlto","product_serie_id":1781,"product_serie_name":"\u6a21\u5757","product_type_id":5,"product_type_name":"\u5b89\u5168\u8bbe\u5907","product_component_id":157,"product_component_name":"\u9632\u706b\u5899\u914d\u4ef6","available_stock_number":"3","purchase_order_un_inbound_number":"3","sales_order_un_outbound_number":"6","outbound_verifying_number":"1","inbound_verifying_number":"0","suggest_purchase_price":6360.9,"stock_number":4,"purchase_demand_number":1,"suggest_purchase_amount":6360.9,"product":{"id":2262,"key":2262,"name":"PAN-SFP-PLUS-SR"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1781,"key":1781,"name":"\u6a21\u5757"},"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":157,"key":157,"name":"\u9632\u706b\u5899\u914d\u4ef6"}},{"product_id":1584,"id":1584,"product_name":"PAN-SVC-BKLN-1420","product_brand_id":8,"product_brand_name":"PaloAlto","product_serie_id":1358,"product_serie_name":"PA-1420\u4e00\u5e74\u670d\u52a1","product_type_id":5,"product_type_name":"\u5b89\u5168\u8bbe\u5907","product_component_id":35,"product_component_name":"\u9632\u706b\u5899\u8f6f\u4ef6","available_stock_number":"0","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"2","outbound_verifying_number":"2","inbound_verifying_number":"0","suggest_purchase_price":21681.66,"stock_number":2,"purchase_demand_number":4,"suggest_purchase_amount":86726.64,"product":{"id":1584,"key":1584,"name":"PAN-SVC-BKLN-1420"},"productBrand":{"id":8,"key":8,"name":"PaloAlto"},"productSerie":{"id":1358,"key":1358,"name":"PA-1420\u4e00\u5e74\u670d\u52a1"},"productType":{"id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},"productComponent":{"id":35,"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6"}},{"product_id":2266,"id":2266,"product_name":"\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20","product_brand_id":286,"product_brand_name":"\u677e\u4e0b","product_serie_id":1783,"product_serie_name":"\u7535\u52a8\u5243\u987b\u5200","product_type_id":23,"product_type_name":"\u793c\u54c1","product_component_id":221,"product_component_name":"\u7535\u5b50\u4ea7\u54c1","available_stock_number":"0","purchase_order_un_inbound_number":"0","sales_order_un_outbound_number":"1","outbound_verifying_number":"0","inbound_verifying_number":"0","suggest_purchase_price":278.04,"stock_number":"0","purchase_demand_number":1,"suggest_purchase_amount":278.04,"product":{"id":2266,"key":2266,"name":"\u677e\u4e0b\u7535\u52a8\u5243\u987b\u5200\u5c0f\u65b9\u76d2mini\u4fbf\u643a\u6b3eCM20"},"productBrand":{"id":286,"key":286,"name":"\u677e\u4e0b"},"productSerie":{"id":1783,"key":1783,"name":"\u7535\u52a8\u5243\u987b\u5200"},"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":221,"key":221,"name":"\u7535\u5b50\u4ea7\u54c1"}}],"pagenation":{"totalcount":62,"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 14:38:28', 51185152) RETURNING "id"
14:38:28.6840.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:38:28.6820.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:38:28.6860.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:38:28.6820.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta