SQL_CALC_FOUND_ROWS query modifier and FOUND_ROWS() are deprecated as of MySQL 8.0.17

[blackcoder87]

Describe the bug
SQL_CALC_FOUND_ROWS and FOUND_ROWS() is used in a few modules for code related to the pagination and in the query builder.
https://github.com/IlchCMS/Ilch-2.0/search?q=SQL_CALC_FOUND_ROWS&unscoped_q=SQL_CALC_FOUND_ROWS
https://github.com/IlchCMS/Ilch-2.0/search?q=getFoundRows&unscoped_q=getFoundRows
https://github.com/IlchCMS/Ilch-2.0/search?q=useFoundRows&unscoped_q=useFoundRows
https://github.com/IlchCMS/Ilch-2.0/wiki/Doku-Entwickler-Database-QueryBuilder#result

The SQL_CALC_FOUND_ROWS query modifier and accompanying FOUND_ROWS() function are deprecated as of MySQL 8.0.17 and will be removed in a future MySQL version. As a replacement, considering executing your query with LIMIT, and then a second query with COUNT(*) and without LIMIT to determine whether there are additional rows.
Source: https://dev.mysql.com/doc/refman/8.0/en/information-functions.html#function_found-rows

Replace the usage of these with a more future proof solution.

Additional context
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html#function_found-rows
https://github.com/IlchCMS/Ilch-2.0/search?q=SQL_CALC_FOUND_ROWS&unscoped_q=SQL_CALC_FOUND_ROWS