Symfony Profiler

SELECT
  MAX(sc.`date`)
FROM
  schedules sc
  JOIN object_multimedia om ON om.`idobject` = sc.`idspectacle`
WHERE
  om.`object` = 'spectacles'
  AND sc.`date` >= '2024-04-26'

SELECT MAX(sc.`date`)
        FROM schedules sc
            JOIN object_multimedia om ON om.`idobject`=sc.`idspectacle`
        WHERE
        om.`object`='spectacles'
        AND sc.`date`>='2024-04-26';

SELECT
  COUNT(
    DISTINCT(s.`idspectacle`)
  )
FROM
  spectacles s
  JOIN schedules sc ON sc.`idspectacle` = s.`idspectacle`
  JOIN object_multimedia om ON om.`idobject` = sc.`idspectacle`
WHERE
  1
  AND (
    sc.date BETWEEN '2024-04-26'
    AND '2025-04-26'
  )
  AND om.`object` = 'spectacles'

SELECT COUNT(DISTINCT(s.`idspectacle`))
                FROM spectacles s JOIN schedules sc ON sc.`idspectacle`=s.`idspectacle` JOIN object_multimedia om ON om.`idobject`=sc.`idspectacle` WHERE 1  AND (sc.date BETWEEN '2024-04-26' AND '2025-04-26')  AND om.`object`= 'spectacles' ;

SELECT
  COUNT(
    DISTINCT (s0_.idschedule)
  ) AS sclr_0,
  MIN(s0_.date) AS sclr_1
FROM
  spectacles s1_
  LEFT JOIN text_spectacle t3_ ON s1_.idspectacle = t3_.idspectacle
  LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext
  LEFT JOIN typesspectacles t4_ ON s1_.idtypespectacle = t4_.idtypespectacle
  LEFT JOIN schedules s0_ ON s1_.idspectacle = s0_.idspectacle
  LEFT JOIN spectacle_person s6_ ON s1_.idspectacle = s6_.idspectacle
  LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson
  INNER JOIN contacts c7_ ON s0_.idcontact = c7_.idcontact
WHERE
  s0_.idspectacle = s1_.idspectacle
  AND (
    s0_.idcontact = c7_.idcontact
    OR s0_.idcontact_festival = c7_.idcontact
  )
  AND (
    (
      s0_.date BETWEEN '2024-04-26'
      AND '2025-04-26'
    )
  )
ORDER BY
  s0_.date ASC

SELECT COUNT(DISTINCT (s0_.idschedule)) AS sclr_0, MIN(s0_.date) AS sclr_1 FROM spectacles s1_ LEFT JOIN text_spectacle t3_ ON s1_.idspectacle = t3_.idspectacle LEFT JOIN texts t2_ ON t2_.idtext = t3_.idtext LEFT JOIN typesspectacles t4_ ON s1_.idtypespectacle = t4_.idtypespectacle LEFT JOIN schedules s0_ ON s1_.idspectacle = s0_.idspectacle LEFT JOIN spectacle_person s6_ ON s1_.idspectacle = s6_.idspectacle LEFT JOIN persons p5_ ON p5_.idperson = s6_.idperson INNER JOIN contacts c7_ ON s0_.idcontact = c7_.idcontact WHERE s0_.idspectacle = s1_.idspectacle AND (s0_.idcontact = c7_.idcontact OR s0_.idcontact_festival = c7_.idcontact) AND ((s0_.date BETWEEN '2024-04-26' AND '2025-04-26')) ORDER BY s0_.date ASC;

SELECT
  DISTINCT(multimedias.idmultimedia),
  multimedias.*,
  spectacles.`idspectacle`,
  schedules.`idcontact`
FROM
  `object_multimedia`,
  `schedules`,
  `spectacles`,
  `contacts`,
  `multimedias`
WHERE
  1
  AND multimedias.`publish` = 1
  AND object_multimedia.`object` = 'spectacles'
  AND object_multimedia.`idrole` IS NULL
  AND schedules.`date` BETWEEN '2024-04-26'
  AND '2025-04-26'
  AND multimedias.`idmultimedia` = object_multimedia.`idmultimedia`
  AND schedules.`idspectacle` = spectacles.`idspectacle`
  AND spectacles.`idspectacle` = object_multimedia.`idobject`
  AND contacts.`idcontact` = schedules.`idcontact`
GROUP BY
  object_multimedia.`idobject`
ORDER BY
  schedules.`date` ASC
LIMIT
  220, 20

SELECT  DISTINCT(multimedias.idmultimedia), multimedias.*,spectacles.`idspectacle`,schedules.`idcontact` 
FROM  `object_multimedia` ,
 `schedules` ,
 `spectacles` ,
 `contacts` ,
 `multimedias`  
 WHERE 1  AND multimedias.`publish`=1  AND object_multimedia.`object`='spectacles'  AND object_multimedia.`idrole` IS NULL  AND schedules.`date` BETWEEN '2024-04-26' AND '2025-04-26'  AND multimedias.`idmultimedia`=object_multimedia.`idmultimedia` AND schedules.`idspectacle`=spectacles.`idspectacle` AND spectacles.`idspectacle`=object_multimedia.`idobject` AND contacts.`idcontact`=schedules.`idcontact` 
 GROUP BY object_multimedia.`idobject` 
ORDER BY schedules.`date` 
ASC 
LIMIT 220,20;

SELECT
  *
FROM
  bannieres
WHERE
  publish = 1
  AND valid = 1
  AND is_national = 1
  AND date_start <= '2024-04-26'
  AND date_end >= '2024-04-26'
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-26'
                AND date_end>='2024-04-26'
                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;