Symfony Profiler

SELECT
  COUNT(*) as total
FROM
  persons

SELECT COUNT(*) as total FROM persons;

SELECT
  COUNT(
    DISTINCT(T1.idperson)
  ) as total
FROM
  persons T1
WHERE
  1
  AND T1.`publish` = 1
  AND T1.lastname REGEXP '^X'

SELECT COUNT(DISTINCT(T1.idperson)) as total  FROM persons T1 WHERE 1  AND T1.`publish`=1 AND T1.lastname REGEXP '^X'  ;

SELECT
  DISTINCT(T1.idperson),
  T1.lastname,
  T1.firstname,
  T1.url_clean
FROM
  persons T1
WHERE
  1
  AND T1.`publish` = 1
  AND T1.lastname REGEXP '^X'
GROUP BY
  T1.idperson
ORDER BY
  T1.lastname ASC
LIMIT
  800, 402

SELECT DISTINCT(T1.idperson), T1.lastname,T1.firstname,T1.url_clean  FROM persons T1 WHERE 1  AND T1.`publish`=1 AND T1.lastname REGEXP '^X'  GROUP BY T1.idperson  ORDER BY T1.lastname ASC LIMIT 800,402;

SELECT
  *
FROM
  bannieres
WHERE
  publish = 1
  AND valid = 1
  AND is_national = 1
  AND date_start <= '2024-06-16'
  AND date_end >= '2024-06-16'
ORDER BY
  bannieres.order ASC
LIMIT
  0, 10

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_national=1
                AND date_start<='2024-06-16'
                AND date_end>='2024-06-16'
                ORDER BY bannieres.order ASC
                LIMIT 0,10;

SELECT
  *
FROM
  bannieres
WHERE
  publish = 1
  AND valid = 1
  AND is_bottom = 1
  AND date_start <= NOW()
  AND date_end >= NOW()
ORDER BY
  bannieres.order ASC
LIMIT
  0, 10

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_bottom=1
                AND date_start<=NOW()
                AND date_end>=NOW()
                ORDER BY bannieres.order ASC
                LIMIT 0,10;