changed select count(*) to select count(id)

select count(*) was logged in slow query, since we are only counting, we can just count one column