When select query having 'having' clause is used in place of 'where' clause i.e. without using a 'group by' statement like this:
select * from sakila.actor having actor_id = 1
It shows wrong number of rows in "Showing rows.." message. It shows total number of rows present in table in the message instead of actual number of rows present in result set.
With reference to this stackoverflow post: http://stackoverflow.com/questions/24384953/phpmyadmin-incorrect-results-count