Performance Profiling

Total processing time: 111 ms; Peak memory: 4.801 MB. Show Profiling Timeline

总计11条数据

Time	Duration	Category	Info

12:05:52.139	22.4 ms	yii\db\Command::query	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))
12:05:52.162	12.1 ms	yii\db\Command::query	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)
12:05:52.178	10.8 ms	yii\db\Command::query	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))
12:05:52.110	6.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
12:05:52.133	5.6 ms	yii\db\Command::query	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)
12:05:52.096	4.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
12:05:52.189	3.1 ms	yii\db\Command::query	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))
12:05:52.128	2.9 ms	yii\db\Command::query	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
12:05:52.175	2.8 ms	yii\db\Command::query	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))
12:05:52.093	2.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
12:05:52.195	2.0 ms	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/engineer', '{"period":"currentfascalyear","engineer":"","web_access_token":"wTKilqflq6B-eOSFd1z6EzcpqcAU3V6m"}', '{"code":2000,"result":{"pre_sales_points":1700,"pre_sales_times":25,"pre_sales_hours":53.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":"221.216.117.119","ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-02 12:05:52', 103784192) RETURNING "id"