Symfony Profiler

SELECT
  COUNT(
    DISTINCT(T1.idperson)
  ) as total
FROM
  persons T1
  JOIN object_file of ON T1.`idperson` = of.`idobject`
  JOIN files f ON of.`idfile` = f.`idfile`
  JOIN file_classification fc ON f.`idfile` = fc.`idfile`
  JOIN spectacle_author sa ON T1.`idperson` = sa.`idperson`
  JOIN spectacles s ON sa.`idspectacle` = s.`idspectacle`
  JOIN text_spectacle ts ON s.`idspectacle` = ts.`idspectacle`
  JOIN texts t ON t.`idtext` = ts.`idtext`
  JOIN schedules sc ON s.`idspectacle` = sc.`idspectacle`
WHERE
  1
  AND fc.`idclassification` = 14
  AND s.`valid` = 1
  AND s.`publish` = 1
  AND s.`textfictif` = 0
  AND T1.`publish` = 1
  AND t.`type` IN (0, 1)
  AND (
    T1.`dateend` IS NULL
    OR T1.`dateend` = 0
    OR T1.`dateend` >= '1954'
  )
LIMIT
  0, 4

SELECT COUNT(DISTINCT(T1.idperson)) as total  FROM persons T1
                    JOIN object_file of ON T1.`idperson`=of.`idobject`
                    JOIN files f ON of.`idfile`=f.`idfile`
                    JOIN file_classification fc ON f.`idfile`=fc.`idfile` 
                            JOIN spectacle_author sa ON T1.`idperson`=sa.`idperson`
                            JOIN spectacles s ON sa.`idspectacle`=s.`idspectacle`
                            JOIN text_spectacle ts ON s.`idspectacle`=ts.`idspectacle`
                            JOIN texts t ON t.`idtext`=ts.`idtext` 
                    JOIN schedules sc ON s.`idspectacle`=sc.`idspectacle`  WHERE 1 
                    AND fc.`idclassification`=14
            
                    AND s.`valid`=1
                    AND s.`publish`=1
                    AND s.`textfictif`=0
                    AND T1.`publish`=1  AND t.`type` IN (0,1)  AND (T1.`dateend` IS NULL OR T1.`dateend` = 0 OR T1.`dateend`>='1954' )  LIMIT 0,4;

SELECT
  DISTINCT(T1.idperson),
  T1.lastname,
  T1.firstname,
  T1.url_clean
FROM
  persons T1
  JOIN object_file of ON T1.`idperson` = of.`idobject`
  JOIN files f ON of.`idfile` = f.`idfile`
  JOIN file_classification fc ON f.`idfile` = fc.`idfile`
  JOIN spectacle_author sa ON T1.`idperson` = sa.`idperson`
  JOIN spectacles s ON sa.`idspectacle` = s.`idspectacle`
  JOIN text_spectacle ts ON s.`idspectacle` = ts.`idspectacle`
  JOIN texts t ON t.`idtext` = ts.`idtext`
  JOIN schedules sc ON s.`idspectacle` = sc.`idspectacle`
WHERE
  1
  AND fc.`idclassification` = 14
  AND s.`valid` = 1
  AND s.`publish` = 1
  AND s.`textfictif` = 0
  AND T1.`publish` = 1
  AND t.`type` IN (0, 1)
  AND (
    T1.`dateend` IS NULL
    OR T1.`dateend` = 0
    OR T1.`dateend` >= '1954'
  )
GROUP BY
  T1.idperson
ORDER BY
  T1.lastname ASC
LIMIT
  650, 50

SELECT DISTINCT(T1.idperson), T1.lastname,T1.firstname,T1.url_clean  FROM persons T1
                    JOIN object_file of ON T1.`idperson`=of.`idobject`
                    JOIN files f ON of.`idfile`=f.`idfile`
                    JOIN file_classification fc ON f.`idfile`=fc.`idfile` 
                            JOIN spectacle_author sa ON T1.`idperson`=sa.`idperson`
                            JOIN spectacles s ON sa.`idspectacle`=s.`idspectacle`
                            JOIN text_spectacle ts ON s.`idspectacle`=ts.`idspectacle`
                            JOIN texts t ON t.`idtext`=ts.`idtext` 
                    JOIN schedules sc ON s.`idspectacle`=sc.`idspectacle`  WHERE 1 
                    AND fc.`idclassification`=14
            
                    AND s.`valid`=1
                    AND s.`publish`=1
                    AND s.`textfictif`=0
                    AND T1.`publish`=1  AND t.`type` IN (0,1)  AND (T1.`dateend` IS NULL OR T1.`dateend` = 0 OR T1.`dateend`>='1954' )  GROUP BY T1.idperson  ORDER BY T1.lastname ASC LIMIT 650,50;

SELECT
  *
FROM
  bannieres
WHERE
  publish = 1
  AND valid = 1
  AND is_national = 1
  AND date_start <= '2024-04-01'
  AND date_end >= '2024-04-01'
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-04-01'
                AND date_end>='2024-04-01'
                ORDER BY bannieres.order ASC
                LIMIT 0,10;

SELECT
  *
FROM
  bannieres
WHERE
  publish = 1
  AND valid = 1
  AND is_region = 1
  AND date_start <= '2024-04-01'
  AND date_end >= '2024-04-01'
  AND (
    region IS NULL
    AND country IS NULL
  )
ORDER BY
  bannieres.order ASC

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_region=1
                AND date_start<='2024-04-01'
                AND date_end>='2024-04-01' AND (region IS NULL AND country IS NULL) ORDER BY bannieres.order ASC ;

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;