I have an innodb table with 100M records like this:

```
id    name   pid cid createdAt
int   char   int int timestamp

```

id is PK, and pid is indexed: `key`

the most often query is `select count(*) from table1 where pid='pid'`

my question is does this query do a full table scanning?