Symfony Profiler

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.start_date AS start_date_1
FROM
  operation o0_
  LEFT JOIN media_object m1_ ON o0_.id = m1_.object_id
  AND m1_.discr IN ('media_game')
  LEFT JOIN media_object m2_ ON o0_.id = m2_.object_id
  AND m2_.discr IN ('media_mobile_game')
WHERE
  (
    o0_.opening_date IS NOT NULL
    AND o0_.opening_date < ?
    AND o0_.end_date IS NOT NULL
    AND o0_.end_date > ?
    AND o0_.online = ?
  )
  AND o0_.discr IN ('game')
ORDER BY
  o0_.start_date ASC
LIMIT
  30

SELECT DISTINCT o0_.id AS id_0, o0_.start_date AS start_date_1 FROM operation o0_ LEFT JOIN media_object m1_ ON o0_.id = m1_.object_id AND m1_.discr IN ('media_game') LEFT JOIN media_object m2_ ON o0_.id = m2_.object_id AND m2_.discr IN ('media_mobile_game') WHERE (o0_.opening_date IS NOT NULL AND o0_.opening_date < '2026-08-02 03:38:38' AND o0_.end_date IS NOT NULL AND o0_.end_date > '2026-08-02 03:38:38' AND o0_.online = 1) AND o0_.discr IN ('game') ORDER BY o0_.start_date ASC LIMIT 30;

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  operation o0_
  LEFT JOIN media_object m1_ ON o0_.id = m1_.object_id
  AND m1_.discr IN ('media_game')
  LEFT JOIN media_object m2_ ON o0_.id = m2_.object_id
  AND m2_.discr IN ('media_mobile_game')
WHERE
  (
    o0_.opening_date IS NOT NULL
    AND o0_.opening_date < ?
    AND o0_.end_date IS NOT NULL
    AND o0_.end_date > ?
    AND o0_.online = ?
  )
  AND o0_.discr IN ('game')

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM operation o0_ LEFT JOIN media_object m1_ ON o0_.id = m1_.object_id AND m1_.discr IN ('media_game') LEFT JOIN media_object m2_ ON o0_.id = m2_.object_id AND m2_.discr IN ('media_mobile_game') WHERE (o0_.opening_date IS NOT NULL AND o0_.opening_date < '2026-08-02 03:38:38' AND o0_.end_date IS NOT NULL AND o0_.end_date > '2026-08-02 03:38:38' AND o0_.online = 1) AND o0_.discr IN ('game');