6a2f60bb2de9a: POST https://beta.jinchangxiao.com/vue/smart-board/engineer at 2026-06-15 10:17:31 am by 124.127.56.185
Database Queries
总计11条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 10:17:31.192 | 0.8 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 10:17:31.194 | 0.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 10:17:31.196 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 10:17:31.203 | 1.0 ms | SELECT | SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='Engineer') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-01-01 00:00:00, 2026-12-31 23:59:59]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 10:17:31.204 | 1.4 ms | SELECT | SELECT COUNT(id) AS times, COALESCE(EXTRACT(epoch FROM SUM(end_at - start_at)) / 3600, 0) AS hours FROM "a57be577deb434"."tbl_pre_sales" WHERE ("created_by" IN (5085, 5248, 1015, 1022, 5064, 1023)) AND ("start_at" >= '2026-01-01 00:00:00') AND ("start_at" <= '2026-12-31 23:59:59') AND ("is_draft"=FALSE) |
| 10:17:31.206 | 5.7 ms | SELECT | SELECT COALESCE(SUM(ca.points), 0) AS points FROM "a57be577deb434"."tbl_case_assignments" "ca" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ca.case_id = c.id WHERE ("c"."case_type"=1) AND ("c"."closed_at" >= '2026-01-01 00:00:00') AND ("c"."closed_at" <= '2026-12-31 23:59:59') AND ("ca"."engineer_id" IN (5085, 5248, 1015, 1022, 5064, 1023)) |
| 10:17:31.212 | 3.0 ms | SELECT | SELECT COUNT(id) AS times, COALESCE(EXTRACT(epoch FROM SUM(left_at - arrived_at)) / 3600, 0) AS hours FROM "a57be577deb434"."tbl_implement_records" WHERE ("created_by" IN (5085, 5248, 1015, 1022, 5064, 1023)) AND ("arrived_at" >= '2026-01-01 00:00:00') AND ("arrived_at" <= '2026-12-31 23:59:59') AND ("is_draft"=FALSE) |
| 10:17:31.216 | 3.4 ms | SELECT | SELECT COALESCE(SUM(ca.points), 0) AS points FROM "a57be577deb434"."tbl_case_assignments" "ca" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ca.case_id = c.id WHERE ("c"."case_type"=2) AND ("c"."closed_at" >= '2026-01-01 00:00:00') AND ("c"."closed_at" <= '2026-12-31 23:59:59') AND ("ca"."engineer_id" IN (5085, 5248, 1015, 1022, 5064, 1023)) |
| 10:17:31.220 | 1.8 ms | SELECT | SELECT COALESCE(SUM(amount), 0) AS total_expense FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (1, 2, 3)) AND ("occurrence_at" >= '2026-01-01') AND ("occurrence_at" <= '2026-12-31 23:59:59') AND ("created_by" IN (5085, 5248, 1015, 1022, 5064, 1023)) |
| 10:17:31.222 | 1.9 ms | SELECT | SELECT COALESCE(SUM(amount), 0) AS total_expense FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (1, 2, 3)) AND ("occurrence_at" >= '2025-01-01') AND ("occurrence_at" <= '2025-12-31 23:59:59') AND ("created_by" IN (5085, 5248, 1015, 1022, 5064, 1023)) |
| 10:17:31.225 | 1.3 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/engineer', '{"period":"currentfascalyear","engineer":"","web_access_token":"JU9Qn0Er55lxUI9CLMF3SA6k67eZ2hvL"}', '{"code":2000,"result":{"pre_sales_points":1700,"pre_sales_times":26,"pre_sales_hours":55.2,"implement_points":7475,"implement_times":126,"implement_hours":397.3,"total_expense":"908113.04","total_expense_last_year":"107218.29","total_expense_growth":7.4697,"engineer_count":6},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"124.127.56.185","ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36 Edg\/149.0.0.0"}', FALSE, '2026-06-15 10:17:31', 35830784) RETURNING "id" |