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

Performance Profiling

Total processing time: 47 ms; Peak memory: 3.902 MB. Show Profiling Timeline

总计7条数据
TimeDurationCategoryInfo
  
11:05:02.55116.4 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 ) AND ("p"."product_brand"='4') ORDER BY p.updated_at DESC nulls last, p.id DESC LIMIT 20
11:05:02.53910.6 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 ) AND ("p"."product_brand"='4') ORDER BY p.updated_at DESC nulls last, p.id DESC) "c"
11:05:02.5691.7 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":"4","product_serie":"","product_type":"","product_component":"","keyword":"","page":"1","web_access_token":"wDahkMIsEuHhAvKCnlYJe0vzWaI3UM9g"}', '{"code":2000,"result":{"list":[{"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":"48","purchase_order_un_inbound_number":"11","sales_order_un_outbound_number":"28","outbound_verifying_number":"6","inbound_verifying_number":"3","suggest_purchase_price":6006.1,"stock_number":54,"purchase_demand_number":-28,"suggest_purchase_amount":-168170.81,"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":714,"id":714,"product_name":"7XB7A00027","product_brand_id":4,"product_brand_name":"\u8054\u60f3","product_serie_id":1200,"product_serie_name":"1.2T 10K 2.5 SAS 12Gb\u786c\u76d8","product_type_id":2,"product_type_name":"\u670d\u52a1\u5668","product_component_id":5,"product_component_name":"\u670d\u52a1\u5668\u786c\u76d8","available_stock_number":"0","purchase_order_un_inbound_number":"2","sales_order_un_outbound_number":"0","outbound_verifying_number":"0","inbound_verifying_number":"0","suggest_purchase_price":0,"stock_number":"0","purchase_demand_number":-2,"suggest_purchase_amount":0,"product":{"id":714,"key":714,"name":"7XB7A00027"},"productBrand":{"id":4,"key":4,"name":"\u8054\u60f3"},"productSerie":{"id":1200,"key":1200,"name":"1.2T 10K 2.5 SAS 12Gb\u786c\u76d8"},"productType":{"id":2,"key":2,"name":"\u670d\u52a1\u5668"},"productComponent":{"id":5,"key":5,"name":"\u670d\u52a1\u5668\u786c\u76d8"}}],"pagenation":{"totalcount":2,"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:05:02', 40804096) RETURNING "id"
11:05:02.5300.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:05:02.5320.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:05:02.5340.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:05:02.5300.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta