SELECT COUNT(*) AS amount3 
    FROM history
    WHERE status = 3;

SELECT COUNT(*) AS amount1 
    FROM history
    WHERE status = 1;

SELECT
    SUM(status = 1) AS amount1,
    SUM(status = 3) AS amount3
    FROM history;

• How to make MySQL using an index only by adding "order by"
• Combined indexes may not work with OR. Try an index_merge in MySQL
• Even LIKE can use an index in SQL. It depends on the wildcard.

PHP 8.2, Laminas MVC 3.2, Symfony 5.2, Laravel 8.28, PHPUnit 9.5, Doctrine ORM 2.8