Why the rows returns by “explain” is not equal to count()?
It is showing how many rows it ran through to get your result. The reason for the wrong data is that EXPLAIN is not accurate, it makes guesses about your data based on information stored about your table. This is very useful information, for example when doing JOINS on many tables and you want to … Read more