mysql> explain SELECT COUNT(*) FROM 2_l10n_community_translation WHERE is_suggestion = 0 AND is_active = 1;
+----+-------------+------------------------------+------+-----------------------------------------------------------------------------------+------+---------+------+---------+-------------+
| id | select_type | table                        | type | possible_keys                                                                     | key  | key_len | ref  | rows    | Extra       |
+----+-------------+------------------------------+------+-----------------------------------------------------------------------------------+------+---------+------+---------+-------------+
|  1 | SIMPLE      | 2_l10n_community_translation | ALL  | 2_l10n_community_translation_is_suggestion,2_l10n_community_translation_is_active | NULL | NULL    | NULL | 4027170 | Using where | 
+----+-------------+------------------------------+------+-----------------------------------------------------------------------------------+------+---------+------+---------+-------------+
1 row in set (0.00 sec)

mysql> explain SELECT COUNT(*) FROM 2_l10n_community_translation WHERE is_suggestion = 0 AND is_active = 1;
+----+-------------+------------------------------+------+------------------------------------------------------------------------------------------------+--------------+---------+-------------+---------+-------------+
| id | select_type | table                        | type | possible_keys                                                                                  | key          | key_len | ref         | rows    | Extra       |
+----+-------------+------------------------------+------+------------------------------------------------------------------------------------------------+--------------+---------+-------------+---------+-------------+
|  1 | SIMPLE      | 2_l10n_community_translation | ref  | 2_l10n_community_translation_is_suggestion,2_l10n_community_translation_is_active,l1tsugactive | l1tsugactive | 8       | const,const | 5086366 | Using index | 
+----+-------------+------------------------------+------+------------------------------------------------------------------------------------------------+--------------+---------+-------------+---------+-------------+