A hundred and one queries for one page

• A

  A missing index on the author table; adding one removes the extra queries

• B

  The connection pool is too small, so queries are being retried

• C

  The N+1 problem; fetch the authors in one query, by joining or by a single batched lookup

• D

  Normalisation has been taken too far here; the author name ought to be copied onto the post