Performance Profiling

Total processing time: 42 ms; Peak memory: 4.735 MB. Show Profiling Timeline

总计33条数据

Time	Duration	Category	Info

15:33:00.191	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')
15:33:00.160	2.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:33:00.185	1.9 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_erp_ticket_change_logs" ("status", "ticket_type", "serial_no", "wrote_date", "description", "abstract", "amount", "client_id", "supplier_id", "contact_id", "user_id", "created_by", "created_at", "updated_at", "object_id", "verify_at") VALUES (2, 20028, 'XSYJFTD-20250915-00001', '2025-09-04', NULL, '6456', '3048204', 3334, NULL, NULL, NULL, 1001, '2025-09-15 15:32:55', '2025-09-15 15:33:00', 8, '2025-09-15 15:33:00.173284+08') RETURNING "id"
15:33:00.158	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:33:00.164	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:33:00.171	1.1 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\ErpProfitDistributeVerifyRels', 14, 'a:2:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";}', '', 1001, '114.246.237.213')
15:33:00.178	1.1 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20028', 8, '刘人诚通过了这个审批', TRUE, 'XSYJFTD-20250915-00001') RETURNING "id"
15:33:00.196	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/verify', '{"id":"8","description":"","web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\u5ba1\u6279\u901a\u8fc7","error":""}],"mod":0}', FALSE, '2025-09-15 15:33:00') RETURNING "id"
15:33:00.189	0.9 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (6, 'status', 8, 20028, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u540c\u610f\u4e86","d3":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355\u7533\u8bf7","d4":""}')
15:33:00.170	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_profit_distribute_verify_rels" SET "status"=1, "description"='', "verify_at"='now()' WHERE "id"=14
15:33:00.180	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3334
15:33:00.173	0.8 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_profit_distributes" SET "status"=2, "verify_at"='now()', "updated_at"='now()' WHERE "id"=8
15:33:00.183	0.8 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', 8, 'a:0:{}', '', 1001, '114.246.237.213')
15:33:00.174	0.8 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', 8, 'a:2:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";}', '', 1001, '114.246.237.213')
15:33:00.195	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=1258, "last_visit_at"='now()' WHERE "id"=56557
15:33:00.179	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\Comments', 191357, 'a:11:{s:2:"id";i:191357;s:9:"object_id";i:8;s:11:"object_type";s:5:"20028";s:6:"parent";N;s:11:"description";s:30:"刘人诚通过了这个审批";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:22:"XSYJFTD-20250915-00001";}', '', 1001, '114.246.237.213')
15:33:00.187	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\ErpTicketChangeLogs', 530, 'a:17:{s:2:"id";i:530;s:9:"serial_no";s:22:"XSYJFTD-20250915-00001";s:11:"ticket_type";i:20028;s:10:"wrote_date";s:10:"2025-09-04";s:6:"status";i:2;s:11:"supplier_id";N;s:9:"client_id";i:3334;s:8:"abstract";s:4:"6456";s:11:"description";N;s:9:"verify_at";s:29:"2025-09-15 15:33:00.173284+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-09-15 15:32:55";s:10:"updated_at";s:19:"2025-09-15 15:33:00";s:10:"contact_id";N;s:7:"user_id";N;s:6:"amount";s:7:"3048204";s:9:"object_id";i:8;}', '', 1001, '114.246.237.213')
15:33:00.184	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3786
15:33:00.182	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_profit_distributes" SET "next_verify_user"=NULL WHERE "id"=8
15:33:00.169	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distribute_verify_rels" WHERE ("status"=0) AND ("erp_profit_distribute_id"=8) ORDER BY "id"
15:33:00.167	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distributes" WHERE "id"='8'
15:33:00.188	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:33:00.172	0.3 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_erp_profit_distribute_verify_rels" WHERE ("status"=0) AND ("erp_profit_distribute_id"=8) ORDER BY "id") "c"
15:33:00.175	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:33:00.189	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:33:00.177	0.3 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
15:33:00.176	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distribute_carbon_copy_rels" WHERE "erp_profit_distribute_id"=8
15:33:00.177	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distributes" WHERE "id"=8
15:33:00.184	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distributes" WHERE "id"=8
15:33:00.175	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distributes" WHERE "id"=8
15:33:00.180	0.2 ms	yii\db\Command::query	SELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL)
15:33:00.176	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distribute_verify_rels" WHERE "erp_profit_distribute_id"=8 ORDER BY "id"
15:33:00.175	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_profit_distribute_verify_rels" WHERE ("status"=0) AND ("erp_profit_distribute_id"=8) ORDER BY "id"