Performance Profiling

Total processing time: 45 ms; Peak memory: 4.978 MB. Show Profiling Timeline

总计29条数据

Time	Duration	Category	Info

16:04:09.093	3.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-15')
16:04:09.074	3.3 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_erp_profit_distributes" ("client_id", "user_id", "project_id", "wrote_date", "serial_no", "abstract", "verify_type", "created_by", "created_at", "status", "is_resubmitted") VALUES (3278, 1001, 3577, '2025-09-15', 'XSYJFTD-20250915-00002', '放上水淀粉', 2, 1001, 'now()', 1, FALSE) RETURNING "id"
16:04:09.058	3.2 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:04:09.061	2.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:04:09.082	2.1 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_erp_profit_distribute_verify_rels" ("erp_profit_distribute_id", "user_id", "status") VALUES (9, 1001, 0)
16:04:09.079	2.1 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20049) AND ("object_id"=9)
16:04:09.065	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:04:09.084	1.5 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_erp_profit_distribute_pcts" ("erp_profit_distribute_id", "user_id", "pct", "description") VALUES (9, 1001, '100', '')
16:04:09.090	1.0 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 9, 20028, 1001, '2025-09-15 16:04:09', '{"id":9,"serial_no":"XSYJFTD-20250915-00002","wrote_date":"2025-09-15","status":1,"abstract":"\u653e\u4e0a\u6c34\u6dc0\u7c89","description":null,"user_id":1001,"client_id":3278,"project_id":3577,"verify_type":2,"next_verify_user":1001,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"created_at":"2025-09-15 16:04:09","updated_at":"2025-09-15 16:04:09"}', '{"id":9,"serial_no":"XSYJFTD-20250915-00002","wrote_date":"2025-09-15","status":1,"abstract":"\u653e\u4e0a\u6c34\u6dc0\u7c89","description":null,"user_id":1001,"client_id":3278,"project_id":3577,"verify_type":2,"next_verify_user":1001,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"created_at":"2025-09-15 16:04:09","updated_at":"2025-09-15 16:04:09"}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\u7533\u8bf7","d4":[]}') RETURNING "id"
16:04:09.078	1.0 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpProfitDistributes', 9, 'a:22:{s:2:"id";i:9;s:9:"serial_no";s:22:"XSYJFTD-20250915-00002";s:10:"wrote_date";s:10:"2025-09-15";s:6:"status";i:1;s:8:"abstract";s:15:"放上水淀粉";s:11:"description";N;s:7:"user_id";s:4:"1001";s:9:"client_id";s:4:"3278";s:10:"project_id";s:4:"3577";s:11:"verify_type";s:1:"2";s:16:"next_verify_user";N;s:21:"next_stop_verify_user";N;s:9:"verify_at";N;s:7:"stop_at";N;s:18:"refuse_description";N;s:14:"is_resubmitted";b:0;s:6:"amount";N;s:10:"created_by";i:1001;s:16:"stop_description";N;s:9:"is_settle";N;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";N;}', '', 1001, '114.246.237.213')
16:04:09.098	1.0 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-profit-distribute/save-new', '{"ErpProfitDistributes":{"id":"","client_id":"3278","client_name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","user_id":"1001","user_name":"\u5218\u4eba\u8bda","project_id":"3577","wrote_date":"2025-09-15","serial_no":"XSYJFTD-20250915-00002","erpProfitDistributeVerifyRels":["1001"],"abstract":"\u653e\u4e0a\u6c34\u6dc0\u7c89","files":"","erpProfitDistributePcts":[{"pct":"100","user_id":"1001","description":""}]},"web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":{"id":9},"status":1,"msg":[{"name":"success","success":"\u65b0\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-09-15 16:04:09') RETURNING "id"
16:04:09.070	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distributes" WHERE ("created_at" >= '2025-09-15 00:00:00') AND ("created_at" <= '2025-09-15 23:59:59') AND ("serial_no" ILIKE '%XSYJFTD-20250915-%') AND (LENGTH(serial_no) = 22) ORDER BY "serial_no" DESC
16:04:09.086	0.8 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_profit_distributes" SET "next_verify_user"=1001 WHERE "id"=9
16:04:09.097	0.8 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=1495, "last_visit_at"='now()' WHERE "id"=56557
16:04:09.092	0.7 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 565424, 'a:13:{s:2:"id";i:565424;s:9:"object_id";i:9;s:11:"object_type";i:20028;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:488:"{"id":9,"serial_no":"XSYJFTD-20250915-00002","wrote_date":"2025-09-15","status":1,"abstract":"\u653e\u4e0a\u6c34\u6dc0\u7c89","description":null,"user_id":1001,"client_id":3278,"project_id":3577,"verify_type":2,"next_verify_user":1001,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"created_at":"2025-09-15 16:04:09","updated_at":"2025-09-15 16:04:09"}";s:9:"new_value";s:488:"{"id":9,"serial_no":"XSYJFTD-20250915-00002","wrote_date":"2025-09-15","status":1,"abstract":"\u653e\u4e0a\u6c34\u6dc0\u7c89","description":null,"user_id":1001,"client_id":3278,"project_id":3577,"verify_type":2,"next_verify_user":1001,"next_stop_verify_user":null,"verify_at":null,"stop_at":null,"refuse_description":null,"is_resubmitted":false,"amount":"0","created_by":1001,"stop_description":null,"is_settle":false,"created_at":"2025-09-15 16:04:09","updated_at":"2025-09-15 16:04:09"}";s:11:"description";s:123:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\u7533\u8bf7","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-09-15 16:04:09";s:9:"is_delete";N;}', '', 1001, '114.246.237.213')
16:04:09.087	0.7 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpProfitDistributes', 9, 'a:0:{}', '', 1001, '114.246.237.213')
16:04:09.071	0.6 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_profit_distributes" WHERE "serial_no"='XSYJFTD-20250915-00002')
16:04:09.072	0.5 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3278')
16:04:09.073	0.5 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3577')
16:04:09.086	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distribute_verify_rels" WHERE ("status"=0) AND ("erp_profit_distribute_id"=9) ORDER BY "id"
16:04:09.090	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:04:09.089	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:04:09.084	0.3 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" WHERE "erp_profit_distribute_id"=9
16:04:09.081	0.2 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_erp_profit_distribute_verify_rels" WHERE "erp_profit_distribute_id"=9
16:04:09.073	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001')
16:04:09.072	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
16:04:09.088	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distributes" WHERE "id"=9
16:04:09.089	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distribute_verify_rels" WHERE ("status"=0) AND ("erp_profit_distribute_id"=9) ORDER BY "id"
16:04:09.089	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distribute_verify_rels" WHERE ("status"=0) AND ("erp_profit_distribute_id"=9) ORDER BY "id"