ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a3a209303bd0: POST https://beta.jinchangxiao.com/vue/smart-board/product-component-list at 2026-06-23 01:58:43 pm by 221.216.117.25

Database Queries

总计7条数据
TimeDurationTypeQuery
  
13:58:43.0201.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
13:58:43.0230.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
13:58:43.0240.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
13:58:43.0322.2 msSELECTSELECT gc.id AS dim_key, gc.name AS name, COALESCE(SUM(eipss.total_amount), 0) AS budget, COALESCE(SUM(eipss.total_amount - COALESCE(eipss.actual_total_amount, 0)), 0) AS profit FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" INNER JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON t.id = eipss.erp_sales_outbound_id INNER JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "sp" ON sp.id = eipss.erp_sales_outbound_spent_product_id INNER JOIN "a57be577deb434"."tbl_products" "prod" ON prod.id = sp.product_id LEFT JOIN "a57be577deb434"."tbl_product_components" "gc" ON gc.id = prod.product_component WHERE ("t"."status"=2) AND ("eipss"."erp_sales_outbound_spent_product_id" IS NOT NULL) AND ("t"."created_at" >= '2026-01-01') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "gc"."id", "gc"."name"

[+] Explain
13:58:43.0352.6 msSELECTSELECT gc.id AS dim_key, gc.name AS name, COALESCE(SUM(eipss.total_amount), 0) AS budget, COALESCE(SUM(eipss.total_amount - COALESCE(eipss.actual_total_amount, 0)), 0) AS profit FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" INNER JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON t.id = eipss.erp_sales_outbound_id INNER JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "sp" ON sp.id = eipss.erp_sales_outbound_spent_product_id INNER JOIN "a57be577deb434"."tbl_products" "prod" ON prod.id = sp.product_id LEFT JOIN "a57be577deb434"."tbl_product_components" "gc" ON gc.id = prod.product_component WHERE ("t"."status"=2) AND ("eipss"."erp_sales_outbound_spent_product_id" IS NOT NULL) AND ("t"."created_at" >= '2025-07-11') AND ("t"."created_at" <= '2025-12-31 23:59:59') GROUP BY "gc"."id", "gc"."name"

[+] Explain
13:58:43.0381.2 msSELECTSELECT gc.id AS dim_key, gc.name AS name, COALESCE(SUM(eipss.total_amount), 0) AS budget, COALESCE(SUM(eipss.total_amount - COALESCE(eipss.actual_total_amount, 0)), 0) AS profit FROM "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" INNER JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON t.id = eipss.erp_sales_outbound_id INNER JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "sp" ON sp.id = eipss.erp_sales_outbound_spent_product_id INNER JOIN "a57be577deb434"."tbl_products" "prod" ON prod.id = sp.product_id LEFT JOIN "a57be577deb434"."tbl_product_components" "gc" ON gc.id = prod.product_component WHERE ("t"."status"=2) AND ("eipss"."erp_sales_outbound_spent_product_id" IS NOT NULL) AND ("t"."created_at" >= '2025-01-01') AND ("t"."created_at" <= '2025-06-23 23:59:59') GROUP BY "gc"."id", "gc"."name"

[+] Explain
13:58:43.0411.9 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/smart-board/product-component-list', '{"period":"currentfascalyear","page":"1","Filter":{"name":"budget","sort":"DESC"},"web_access_token":"s1xKbg9e3rlah-dvFsDEWCxiJPk9VpSm"}', '{"code":2000,"result":{"list":[{"key":52,"name":"\u534f\u4f5c","budget":"13036952","profit":"12749644.795","prev_budget":"0","prev_profit":"0","prev_budget_growth":"1","prev_profit_growth":"1","last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":151,"name":"\u4eba\u5de5\u670d\u52a1","budget":"2710226","profit":"165808","prev_budget":"1665729","prev_profit":"1065151","prev_budget_growth":0.627,"prev_profit_growth":-0.8443,"last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":226,"name":"\u667a\u7b97\u4e00\u4f53\u673a","budget":"1220108","profit":"36604","prev_budget":"0","prev_profit":"0","prev_budget_growth":"1","prev_profit_growth":"1","last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":30,"name":"\u5907\u4efd\u8f6f\u4ef6","budget":"654621.2","profit":"355829.2","prev_budget":"136950","prev_profit":"85690","prev_budget_growth":3.78,"prev_profit_growth":3.1525,"last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":26,"name":"\u9632\u706b\u5899\u4e3b\u673a","budget":"621501","profit":"177718.8","prev_budget":"527660","prev_profit":"109897.00","prev_budget_growth":0.1778,"prev_profit_growth":0.6171,"last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":36,"name":"PA\u8bb8\u53ef\u8bc1","budget":"553118","profit":"206590","prev_budget":"629020.99","prev_profit":"92868.99","prev_budget_growth":-0.1206,"prev_profit_growth":1.2245,"last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":35,"name":"\u9632\u706b\u5899\u8f6f\u4ef6","budget":"443712","profit":"129316","prev_budget":"354219.4","prev_profit":"53191.00","prev_budget_growth":0.2526,"prev_profit_growth":1.4311,"last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":214,"name":"\u9632\u706b\u5899\u670d\u52a1","budget":"210375","profit":"82097","prev_budget":"457510","prev_profit":"373937.00","prev_budget_growth":-0.5401,"prev_profit_growth":-0.7804,"last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":48,"name":"\u6570\u636e\u5e93","budget":"137520","profit":"31520","prev_budget":"0","prev_profit":"0","prev_budget_growth":"1","prev_profit_growth":"1","last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"},{"key":169,"name":"\u5b89\u5168\u6258\u7ba1\u670d\u52a1","budget":"117000","profit":"40080","prev_budget":"0","prev_profit":"0","prev_budget_growth":"1","prev_profit_growth":"1","last_budget":"0","last_profit":"0","budget_growth":"1","profit_growth":"1"}],"pagenation":{"totalcount":35,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-06-23 13:58:43', 24047872) RETURNING "id"

[+] Explain