Uses includes for venue

Uses includes for organizer

No eager_load for simple associations

Model scope for eager loading

Counter cache on Comment

Counter cache on EventVendor

Migration adds counter cache columns

No .count on associations in view or controller

pluck or select used appropriately

CHANGES.md explains method selection

Scope used in controller

Correct includes nesting syntax

Index on user_id FK

Index on show_id FK

Index on venue_id FK

Composite index for user+status query

Partial index for active statuses

MIGRATION_NOTES explains each index

Bulk update uses update_all

No AR object instantiation for bulk update

Script runnable via rails runner

Index comment order matters

No redundant single-column indexes

Covering or include index considered

bullet gem in dev/test group

rack-mini-profiler gem present

stackprof gem present

Bullet dev config block

Bullet.raise in test env

rack-mini-profiler position config

rack-mini-profiler start_hidden false

Slow query subscriber threshold 100ms

Bullet RSpec before/after hooks

QueryCounter module

around_action log_query_count

warn_on_records_fetched config

memory_profiler gem present

Bullet.raise NOT in development