Performance Profiling

Total processing time: 457 ms; Peak memory: 4.832 MB. Show Profiling Timeline

总计11条数据

Time	Duration	Category	Info

16:29:34.130	9.0 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))
16:29:34.078	7.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:29:34.071	6.6 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:29:34.116	5.6 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))
16:29:34.141	4.0 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))
16:29:34.126	3.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"=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))
16:29:34.122	3.3 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)
16:29:34.152	2.8 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":""}', '{"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":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-06 16:29:34', 436352000) RETURNING "id"
16:29:34.103	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:29:34.114	1.8 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)
16:29:34.112	1.2 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