Tag selection box is very slow to load in development mode

[fbacall]

Adds 5 seconds to page load with 3k SQL queries for me:
Rendering: tags/_select_tags.html.erb 5273.2 +3441.8 3390 sql 317.9

Could be cut down by doing the count in the SQL query:

class Annotation < ApplicationRecord
...
  belongs_to :text_value, -> { where(annotations: { value_type: 'TextValue' }) }, foreign_key: :value_id
...
end


suggested_tags = Annotation.with_attribute_name(type)
  .joins(:text_value)
  .select('text_values.text', 'count(value_id) AS tag_count')
  .group(:value_id).reorder('tag_count desc').limit(suggested_limit)

Before:

After: