perf(plugins): removes DB query to determine if a plugin is active

This also modernizes the plugin_id to object map to use a MemoryPool.

Fixes #7661
I generally dislike work done in the constructor other than signing private variables. Side effects on instantiation are a bit unexpected.