Performance Profiling

Total processing time: 41 ms; Peak memory: 4.811 MB. Show Profiling Timeline

总计33条数据

Time	Duration	Category	Info

11:44:49.424	3.7 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-17')
11:44:49.394	2.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:44:49.392	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:44:49.397	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:44:49.418	1.4 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, 20016, 'FYZSRD-20250917-00012', '2025-09-17', '修复BUG 其他收入费用转收入收入科目冲突问题影响范围其他收入费用转收入增删改查', '修复BUG 其他收入费用转收入收入科目冲突问题影响范围其他收入费用转收入增删改查', '8', NULL, NULL, NULL, NULL, 1001, '2025-09-17 11:43:56', '2025-09-17 11:44:49', 15, '2025-09-17 11:44:49.4072+08') RETURNING "id"
11:44:49.420	1.2 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_erp_ticket_change_log_handlers" ("erp_ticket_change_log_id", "user_id") VALUES (585, 1001), (585, 5332)
11:44:49.405	1.2 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\ErpCostConvertTicketVerifyRels', 8, 'a:2:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";}', '', 1001, '114.244.128.96')
11:44:49.412	1.1 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20016', 15, '刘人诚通过了这个审批', TRUE, 'FYZSRD-20250917-00012') RETURNING "id"
11:44:49.429	1.1 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-cost-convert-ticket/verify', '{"id":"15","description":"","web_access_token":"sXjqURNBCao5nldOR3zGEIU34GY49pIi"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u8d39\u7528\u8f6c\u5176\u4ed6\u6536\u5165\u5355\u5ba1\u6279\u901a\u8fc7","error":""}],"mod":0}', FALSE, '2025-09-17 11:44:49') RETURNING "id"
11:44:49.423	1.0 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', 15, 20016, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u540c\u610f\u4e86","d3":"\u8d39\u7528\u8f6c\u5176\u4ed6\u6536\u5165\u5355\u7533\u8bf7","d4":""}')
11:44:49.415	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 ('UPDATE', 'app\models\ErpCostConvertTickets', 15, 'a:0:{}', '', 1001, '114.244.128.96')
11:44:49.403	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" SET "status"=1, "description"='', "verify_at"='now()' WHERE "id"=8
11:44:49.407	0.8 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_cost_convert_tickets" SET "status"=2, "verify_at"='now()', "updated_at"='now()' WHERE "id"=15
11:44:49.419	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 ('INSERT', 'app\models\ErpTicketChangeLogs', 585, 'a:17:{s:2:"id";i:585;s:9:"serial_no";s:21:"FYZSRD-20250917-00012";s:11:"ticket_type";i:20016;s:10:"wrote_date";s:10:"2025-09-17";s:6:"status";i:2;s:11:"supplier_id";N;s:9:"client_id";N;s:8:"abstract";s:119:"修复BUG 其他收入费用转收入收入科目冲突问题影响范围其他收入费用转收入增删改查";s:11:"description";s:119:"修复BUG 其他收入费用转收入收入科目冲突问题影响范围其他收入费用转收入增删改查";s:9:"verify_at";s:27:"2025-09-17 11:44:49.4072+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-09-17 11:43:56";s:10:"updated_at";s:19:"2025-09-17 11:44:49";s:10:"contact_id";N;s:7:"user_id";N;s:6:"amount";s:1:"8";s:9:"object_id";i:15;}', '', 1001, '114.244.128.96')
11:44:49.428	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=371, "last_visit_at"='now()' WHERE "id"=56609
11:44:49.413	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', 191433, 'a:11:{s:2:"id";i:191433;s:9:"object_id";i:15;s:11:"object_type";s:5:"20016";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:21:"FYZSRD-20250917-00012";}', '', 1001, '114.244.128.96')
11:44:49.408	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\ErpCostConvertTickets', 15, 'a:2:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";}', '', 1001, '114.244.128.96')
11:44:49.415	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_cost_convert_tickets" SET "next_verify_user"=NULL WHERE "id"=15
11:44:49.402	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" WHERE ("status"=0) AND ("erp_cost_convert_ticket_id"=15) ORDER BY "id"
11:44:49.400	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" WHERE "id"='15'
11:44:49.422	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:44:49.406	0.3 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" WHERE ("status"=0) AND ("erp_cost_convert_ticket_id"=15) ORDER BY "id") "c"
11:44:49.409	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:44:49.422	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:44:49.411	0.3 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
11:44:49.417	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" WHERE "erp_cost_convert_ticket_id"=15
11:44:49.410	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_carbon_copy_rels" WHERE "erp_cost_convert_ticket_id"=15
11:44:49.417	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" WHERE "id"=15
11:44:49.411	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" WHERE "id"=15
11:44:49.408	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" WHERE "id"=15
11:44:49.414	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)
11:44:49.409	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" WHERE ("status"=0) AND ("erp_cost_convert_ticket_id"=15) ORDER BY "id"
11:44:49.410	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_verify_rels" WHERE "erp_cost_convert_ticket_id"=15 ORDER BY "id"