Performance Profiling

Total processing time: 417 ms; Peak memory: 4.939 MB. Show Profiling Timeline

总计37条数据

Time	Duration	Category	Info

16:31:10.096	90.5 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=7502) AND ("object_type"=20018)) OR (("target_id"=7502) AND ("target_object_type"=20018))
16:31:10.329	87.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=8154) AND ("object_type"=20)) OR (("target_id"=8154) AND ("target_object_type"=20))
16:31:10.250	66.8 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=8154) AND ("object_type"=20)
16:31:10.425	22.2 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=8154) AND ("object_type"=20)
16:31:10.067	15.8 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=7502) AND ("object_type"=20018)
16:31:10.447	14.1 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=8154) AND ("object_type"=20)
16:31:10.212	13.9 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=7502) AND ("object_type"=20018)
16:31:10.083	11.8 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=7502) AND ("object_type"=20018)
16:31:10.237	11.5 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=7502
16:31:10.317	11.2 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=8154) AND ("object_type"=20)
16:31:10.226	11.1 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=7502) AND ("object_type"=20018)
16:31:10.192	4.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" WHERE "erp_cash_cost_ticket_id"=7502 ORDER BY "id"
16:31:10.461	3.7 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"=8154
16:31:10.419	3.2 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=8154)
16:31:10.202	2.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" WHERE "erp_cash_cost_ticket_id"=7502 ORDER BY "id"
16:31:10.210	2.3 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20032) AND ("object_id"=7502)
16:31:10.056	2.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:31:10.207	2.1 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20031) AND ("object_id"=7502)
16:31:10.186	2.1 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_cash_cost_tickets" SET "status"=6 WHERE "id"=7502
16:31:10.422	2.1 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id"=8154)
16:31:10.055	1.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:31:10.060	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:31:10.064	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "reimbursement_id"=8154
16:31:10.198	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" WHERE "erp_cash_cost_ticket_id"=7502 ORDER BY "id"
16:31:10.206	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_approve_payment_settles" WHERE "erp_cash_cost_ticket_id"=7502 ORDER BY "id"
16:31:10.417	1.2 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8154) AND ("term_id"=15)
16:31:10.189	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\ErpCashCostTickets', 7502, 'a:1:{s:6:"status";i:6;}', '', 1001, '114.244.128.96')
16:31:10.467	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/reimbursement/delete', '{"id":"8154","web_access_token":"dut1vXihUglGelt2KMXELnSbFppny3OV"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u62a5\u9500\u5df2\u88ab\u6210\u529f\u5220\u9664","error":""}],"mod":0}', FALSE, '2025-09-17 16:31:10') RETURNING "id"
16:31:10.418	0.8 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8154) AND ("object_type"=7)
16:31:10.201	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\ErpCashCostTickets', 7502, 'a:0:{}', '', 1001, '114.244.128.96')
16:31:10.465	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 ('DELETE', 'app\models\Reimbursements', 8154, '', '', 1001, '114.244.128.96')
16:31:10.249	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 ('DELETE', 'app\models\ErpCashCostTickets', 7502, '', '', 1001, '114.244.128.96')
16:31:10.200	0.8 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_cash_cost_tickets" SET "is_payment_settle"=TRUE WHERE "id"=7502
16:31:10.063	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "id"='8154'
16:31:10.095	0.4 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=7502) AND ("object_type"=20018)
16:31:10.190	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=7502
16:31:10.328	0.2 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=8154) AND ("object_type"=20)