Two issues with this method:
1. It uses a scope (bmc) to access the interfaces which causes a query, even if the interfaces are already preloaded into the host.
2. The result is not cached either, which means multiple accesses to #bmc_nic will cause multiple queries. For example accessing #sp_ip and #sp_mac.

Good example when it's happening is api hosts index query.