How I Cut an EF Core Endpoint’s Response Time by 50% With Dapper and Raw SQL

The execution plan, the missing index, and the raw SQL query that saved one job portal’s busiest page.