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
Log Messages
总计38条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 13:59:26.955 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 13:59:26.955 | trace | yii\base\Module::getModule | Loading module: debug |
| 13:59:26.956 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 13:59:26.957 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 13:59:26.957 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 13:59:26.957 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 13:59:26.958 | info | time tracing start | 1782194366958180864 |
| 13:59:26.958 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 13:59:26.958 | trace | yii\web\Application::handleRequest | Route requested: 'vue/smart-board/product-model-list' |
| 13:59:26.958 | trace | yii\base\Module::getModule | Loading module: vue |
| 13:59:26.959 | info | yii\web\Session::open | Session started |
| 13:59:26.961 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 13:59:26.961 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 13:59:26.963 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 13:59:26.963 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 13:59:26.964 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 13:59:26.965 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 13:59:26.965 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 13:59:26.966 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 13:59:26.966 | trace | yii\base\Controller::runAction | Route to run: vue/smart-board/product-model-list |
| 13:59:26.967 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 13:59:26.969 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 13:59:26.969 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\SmartBoardController::actionProductModelList() |
| 13:59:26.969 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 13:59:26.970 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 13:59:26.972 | info | yii\db\Command::query | 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.974 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 13:59:26.975 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 13:59:26.976 | info | yii\db\Command::query | 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 | info | yii\db\Command::query | 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 | info | yii\db\Command::query | 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.983 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 13:59:26.983 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 13:59:26.984 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 13:59:26.984 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 13:59:26.985 | info | 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/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" |
| 13:59:26.987 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 13:59:26.987 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |