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;

• Combined indexes may not work with OR. Try an index_merge in MySQL
• Doing math in SQL can ignore indices
• Prevent a temporary DB table caused by SQL group by

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