6a3a20bee9940: POST https://beta.jinchangxiao.com/vue/smart-board/product-model-list at 2026-06-23 01:59:26 pm by 221.216.117.25
Database Queries
总计8条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 13:59:26.961 | 1.0 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 13:59:26.964 | 0.8 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 13:59:26.966 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 13:59:26.972 | 2.3 ms | SELECT | SELECT prod.id AS dim_key, prod.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 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 "prod"."id", "prod"."name" |
| 13:59:26.976 | 2.7 ms | SELECT | SELECT prod.id AS dim_key, prod.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 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 "prod"."id", "prod"."name" |
| 13:59:26.979 | 1.0 ms | SELECT | SELECT prod.id AS dim_key, prod.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 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 "prod"."id", "prod"."name" |
| 13:59:26.981 | 2.1 ms | SELECT | SELECT "prod"."id", gb.name AS brand_name, gt.name AS type_name, gc.name AS component_name, gs.name AS serie_name FROM "a57be577deb434"."tbl_products" "prod" LEFT JOIN "a57be577deb434"."tbl_product_brands" "gb" ON gb.id = prod.product_brand LEFT JOIN "a57be577deb434"."tbl_product_types" "gt" ON gt.id = prod.product_type LEFT JOIN "a57be577deb434"."tbl_product_components" "gc" ON gc.id = prod.product_component LEFT JOIN "a57be577deb434"."tbl_product_series" "gs" ON gs.id = prod.product_serie WHERE "prod"."id" IN (2231, 984, 1528, 868, 2253, 1774, 867, 2269, 2227, 1671, 2244, 1890, 2241, 1876, 1148, 1973, 855, 1007, 2228, 870, 1880, 942, 941, 2261, 1882, 1558, 2237, 1096, 851, 2258, 2243, 1942, 2232, 2041, 2230, 2171, 1511, 1340, 1928, 41, 2238, 2233, 587, 1562, 2224, 2259, 2235, 2225, 989, 2236, 1925, 922, 2240, 994, 154, 1929, 1927, 2239, 2257, 969, 1737, 1780, 2177, 1923, 1275, 960, 2260, 2226, 1339) |
| 13:59:26.985 | 1.9 ms | INSERT | 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/smart-board/product-model-list', '{"period":"currentfascalyear","page":"1","Filter":{"name":"budget","sort":"DESC"},"web_access_token":"s1xKbg9e3rlah-dvFsDEWCxiJPk9VpSm"}', '{"code":2000,"result":{"list":[{"key":2261,"name":"MK-MC300","budget":"12703072","profit":"12702289.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","brand_name":"\u8054\u60f3","type_name":"\u7f51\u7edc\u8bbe\u5907 ","component_name":"\u534f\u4f5c","serie_name":"\u5168\u5411\u9ea6\u514b\u98ce"},{"key":2238,"name":"WS-S1-MD","budget":"1759616","profit":"52788","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","brand_name":"\u4e2d\u535a\u6570\u667a","type_name":"\u6280\u672f\u670d\u52a1","component_name":"\u4eba\u5de5\u670d\u52a1","serie_name":"\u4e2d\u535a\u6570\u667a\u6280\u672f\u670d\u52a1"},{"key":2237,"name":"ZB-W8G40PXL","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","brand_name":"\u4e2d\u535a\u6570\u667a","type_name":"\u670d\u52a1\u5668","component_name":"\u667a\u7b97\u4e00\u4f53\u673a","serie_name":"\u5168\u6db2\u51b7\u667a\u7b97\u4e00\u4f53\u673a"},{"key":2240,"name":"WS-S1-SNGIO","budget":"678046","profit":"20342","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","brand_name":"\u4e2d\u535a\u6570\u667a","type_name":"\u6280\u672f\u670d\u52a1","component_name":"\u4eba\u5de5\u670d\u52a1","serie_name":"\u4e2d\u535a\u6570\u667a\u6280\u672f\u670d\u52a1"},{"key":1942,"name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6 V6","budget":"568521","profit":"318521","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","brand_name":"\u58f9\u8fdb\u5236","type_name":"\u8f6f\u4ef6","component_name":"\u5907\u4efd\u8f6f\u4ef6","serie_name":"\u58f9\u8fdb\u5236\u9ed1\u65b9\u5bb9\u707e\u5907\u4efd\u4e0e\u6062\u590d\u7cfb\u7edf\u8f6f\u4ef6 V6.0"},{"key":2231,"name":"PAN-PA-3440-ATP-3YR","budget":"399484","profit":"155896","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","brand_name":"PaloAlto","type_name":"\u5b89\u5168\u8bbe\u5907","component_name":"PA\u8bb8\u53ef\u8bc1","serie_name":"PA3440\u8f6f\u4ef6\u6388\u6743"},{"key":2241,"name":"XMS1000","budget":"312000","profit":"47700","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","brand_name":"\u5c0f\u9c7c\u6613\u8fde","type_name":"\u7f51\u7edc\u8bbe\u5907 ","component_name":"\u534f\u4f5c","serie_name":"\u89c6\u9891\u4f1a\u8bae\u5e73\u53f0"},{"key":2230,"name":"PAN-PA-3440","budget":"275603","profit":"106055","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","brand_name":"PaloAlto","type_name":"\u5b89\u5168\u8bbe\u5907","component_name":"\u9632\u706b\u5899\u4e3b\u673a","serie_name":"PA-3440\u9632\u706b\u5899\u4e3b\u673a"},{"key":1973,"name":"PAN-PA-1410-BND-CORESEC-3YR","budget":"260000","profit":"81864","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","brand_name":"PaloAlto","type_name":"\u5b89\u5168\u8bbe\u5907","component_name":"\u9632\u706b\u5899\u8f6f\u4ef6","serie_name":"PA-1410\u4e09\u5e74\u670d\u52a1"},{"key":2232,"name":"PAN-SVC-BKLN-3440-3YR","budget":"210375","profit":"82097","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","brand_name":"PaloAlto","type_name":"\u5b89\u5168\u8bbe\u5907","component_name":"\u9632\u706b\u5899\u670d\u52a1","serie_name":"\u4e09\u5e74\u670d\u52a1"}],"pagenation":{"totalcount":69,"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:59:26', 26729984) RETURNING "id" |