Symfony Profiler

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.position AS position_1
FROM
  slider s0_
  LEFT JOIN media_object m1_ ON s0_.id = m1_.object_id
  AND m1_.discr IN ('media_slider')
  LEFT JOIN media_object m2_ ON s0_.id = m2_.object_id
  AND m2_.discr IN ('media_mobile_slider')
WHERE
  s0_.start_date IS NOT NULL
  AND s0_.start_date < ?
  AND s0_.end_date IS NOT NULL
  AND s0_.end_date > ?
  AND s0_.online = ?
ORDER BY
  s0_.position ASC
LIMIT
  30

SELECT DISTINCT s0_.id AS id_0, s0_.position AS position_1 FROM slider s0_ LEFT JOIN media_object m1_ ON s0_.id = m1_.object_id AND m1_.discr IN ('media_slider') LEFT JOIN media_object m2_ ON s0_.id = m2_.object_id AND m2_.discr IN ('media_mobile_slider') WHERE s0_.start_date IS NOT NULL AND s0_.start_date < '2026-05-24 06:35:22' AND s0_.end_date IS NOT NULL AND s0_.end_date > '2026-05-24 06:35:22' AND s0_.online = 1 ORDER BY s0_.position ASC LIMIT 30;

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  slider s0_
  LEFT JOIN media_object m1_ ON s0_.id = m1_.object_id
  AND m1_.discr IN ('media_slider')
  LEFT JOIN media_object m2_ ON s0_.id = m2_.object_id
  AND m2_.discr IN ('media_mobile_slider')
WHERE
  s0_.start_date IS NOT NULL
  AND s0_.start_date < ?
  AND s0_.end_date IS NOT NULL
  AND s0_.end_date > ?
  AND s0_.online = ?

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM slider s0_ LEFT JOIN media_object m1_ ON s0_.id = m1_.object_id AND m1_.discr IN ('media_slider') LEFT JOIN media_object m2_ ON s0_.id = m2_.object_id AND m2_.discr IN ('media_mobile_slider') WHERE s0_.start_date IS NOT NULL AND s0_.start_date < '2026-05-24 06:35:22' AND s0_.end_date IS NOT NULL AND s0_.end_date > '2026-05-24 06:35:22' AND s0_.online = 1;