如何优化大表上的count SQL查询

I have a big table on mysql (innodb) which contains products assets (13 millions of rows). Here a little schema of my database :I have a big table on mysql (innodb) which cont