6877459594c72: POST https://beta.jinchangxiao.com/vue/dashboard/engineer-score at 2025-07-16 02:24:21 pm by 124.127.56.185
Database Queries
总计5条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:24:21.614 | 2.5 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:24:21.619 | 3.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:24:21.622 | 3.5 ms | SELECT | SELECT u.id, name, esb.*, e_implement_count, e_budget_count, e_profit_count, e_client_count, e_project_count, e_point_count, (CASE WHEN esb.e_implement_base > 0 THEN floor(u.e_implement_count * 20 / esb.e_implement_base) ELSE 0 END) as e_implement_score, (CASE WHEN esb.e_budget_base > 0 THEN floor(u.e_budget_count * 20 / esb.e_budget_base) ELSE 0 END) as e_budget_score, (CASE WHEN esb.e_profit_base > 0 THEN floor(u.e_profit_count * 15 / esb.e_profit_base) ELSE 0 END) as e_profit_score, (CASE WHEN esb.e_client_base > 0 THEN floor(u.e_client_count * 15 / esb.e_client_base) ELSE 0 END) as e_client_score, (CASE WHEN esb.e_project_base > 0 THEN floor(u.e_project_count * 15 / esb.e_project_base) ELSE 0 END) as e_project_score, (CASE WHEN esb.e_point_base > 0 THEN floor(u.e_point_count * 15 / esb.e_point_base) ELSE 0 END) as e_point_score, ( (CASE WHEN esb.e_implement_base > 0 THEN floor(u.e_implement_count * 20 / esb.e_implement_base) ELSE 0 END) + (CASE WHEN esb.e_budget_base > 0 THEN floor(u.e_budget_count * 20 / esb.e_budget_base) ELSE 0 END) + (CASE WHEN esb.e_profit_base > 0 THEN floor(u.e_profit_count * 15 / esb.e_profit_base) ELSE 0 END) + (CASE WHEN esb.e_client_base > 0 THEN floor(u.e_client_count * 15 / esb.e_client_base) ELSE 0 END) + (CASE WHEN esb.e_project_base > 0 THEN floor(u.e_project_count * 15 / esb.e_project_base) ELSE 0 END) + (CASE WHEN esb.e_point_base > 0 THEN floor(u.e_point_count * 15 / esb.e_point_base) ELSE 0 END) ) as score FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON u.id = aa.user_id LEFT JOIN "a57be577deb434"."tbl_engineer_score_bases" "esb" ON 1 = 1 WHERE ("u"."user_status"=1) AND ("u"."id"=1001) AND ("aa"."item_name"='Engineer') GROUP BY "u"."id", "esb"."id" |
| 14:24:21.626 | 2.0 ms | SELECT | SELECT avg( (CASE WHEN esb.e_implement_base > 0 THEN floor(u.e_implement_count * 20 / esb.e_implement_base) ELSE 0 END) + (CASE WHEN esb.e_budget_base > 0 THEN floor(u.e_budget_count * 20 / esb.e_budget_base) ELSE 0 END) + (CASE WHEN esb.e_profit_base > 0 THEN floor(u.e_profit_count * 15 / esb.e_profit_base) ELSE 0 END) + (CASE WHEN esb.e_client_base > 0 THEN floor(u.e_client_count * 15 / esb.e_client_base) ELSE 0 END) + (CASE WHEN esb.e_project_base > 0 THEN floor(u.e_project_count * 15 / esb.e_project_base) ELSE 0 END) + (CASE WHEN esb.e_point_base > 0 THEN floor(u.e_point_count * 15 / esb.e_point_base) ELSE 0 END) ) as score FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON u.id = aa.user_id LEFT JOIN "a57be577deb434"."tbl_engineer_score_bases" "esb" ON 1 = 1 WHERE ("u"."user_status"=1) AND ("aa"."item_name"='Engineer') |
| 14:24:21.632 | 1.8 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/dashboard/engineer-score', '{"web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"name":"\u5218\u4eba\u8bda","score":0,"avg_score":38,"items":[{"key":"e_implement_info","title":"\u672c\u8d22\u5e74\u5b9e\u65bd\u6b21\u6570","base_score":"20","score":0,"pct":0,"count":0,"base":"51","display":"\u672a\u8fbe\u6807"},{"key":"e_budget_info","title":"\u672c\u8d22\u5e74\u52a9\u653b\u6d41\u6c34","base_score":"20","score":0,"pct":0,"count":0,"base":"132738.2","display":"\u672a\u8fbe\u6807"},{"key":"e_profit_info","title":"\u672c\u8d22\u5e74\u52a9\u653b\u5229\u6da6","base_score":"15","score":0,"pct":0,"count":0,"base":"24631.6174200000000000","display":"\u672a\u8fbe\u6807"},{"key":"e_client_info","title":"\u672c\u8d22\u5e74\u670d\u52a1\u5ba2\u6237\u6570","base_score":"15","score":0,"pct":0,"count":0,"base":"17","display":"\u672a\u8fbe\u6807"},{"key":"e_project_info","title":"\u672c\u8d22\u5e74\u670d\u52a1\u5546\u673a\u6570","base_score":"15","score":0,"pct":0,"count":0,"base":"22","display":"\u672a\u8fbe\u6807"},{"key":"e_point_info","title":"\u672c\u8d22\u5e74\u5de5\u5206","base_score":"15","score":0,"pct":0,"count":0,"base":"2239","display":"\u672a\u8fbe\u6807"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-16 14:24:21') RETURNING "id" |