Performance Profiling

Total processing time: 81 ms; Peak memory: 3.896 MB. Show Profiling Timeline

总计7条数据

Time	Duration	Category	Info

14:40:11.737	31.0 ms	yii\db\Command::query	SELECT 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 ((lower(p.name) ILIKE '%密封罐%') OR (lower(p.pinyin_shortcut) ILIKE '%密封罐%') OR (lower(pb.name) ILIKE '%密封罐%') OR (lower(ps.name) ILIKE '%密封罐%') OR (lower(pt.name) ILIKE '%密封罐%') OR (lower(pc.name) ILIKE '%密封罐%')) ORDER BY p.updated_at DESC nulls last, p.id DESC) "c"
14:40:11.769	29.4 ms	yii\db\Command::query	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 ((lower(p.name) ILIKE '%密封罐%') OR (lower(p.pinyin_shortcut) ILIKE '%密封罐%') OR (lower(pb.name) ILIKE '%密封罐%') OR (lower(ps.name) ILIKE '%密封罐%') OR (lower(pt.name) ILIKE '%密封罐%') OR (lower(pc.name) ILIKE '%密封罐%')) ORDER BY p.updated_at DESC nulls last, p.id DESC LIMIT 20
14:40:11.801	1.9 ms	yii\db\Command::query	INSERT 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":"\u5bc6\u5c01\u7f50","page":"1","web_access_token":"wDahkMIsEuHhAvKCnlYJe0vzWaI3UM9g"}', '{"code":2000,"result":{"list":[{"product_id":2091,"id":2091,"product_name":"\u5bc6\u5c01\u7f50\u73bb\u7483\u74f6\u5b50","product_brand_id":134,"product_brand_name":"\u7b2c\u4e09\u65b9","product_serie_id":"","product_serie_name":"","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":"0","purchase_order_un_inbound_number":"10","sales_order_un_outbound_number":"5","outbound_verifying_number":"0","inbound_verifying_number":"2","suggest_purchase_price":9.33,"stock_number":"0","purchase_demand_number":-7,"suggest_purchase_amount":-65.31,"product":{"id":2091,"key":2091,"name":"\u5bc6\u5c01\u7f50\u73bb\u7483\u74f6\u5b50"},"productBrand":{"id":134,"key":134,"name":"\u7b2c\u4e09\u65b9"},"productSerie":{"id":"","key":"","name":""},"productType":{"id":23,"key":23,"name":"\u793c\u54c1"},"productComponent":{"id":195,"key":195,"name":"\u8425\u517b\u98df\u54c1\u6ecb\u8865"}}],"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 14:40:11', 74595072) RETURNING "id"
14:40:11.728	0.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:40:11.730	0.6 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:40:11.732	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:40:11.728	0.3 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta