Similar article of mine from 2013: https://cloudinvent.com/blog/optimize-mysql-count-query/