Symfony Profiler

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  service s0_
  LEFT JOIN category c1_ ON s0_.category_id = c1_.id
WHERE
  s0_.status = ?
  AND s0_.deleted_at IS NULL
  AND c1_.slug IN (?)

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM service s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id WHERE s0_.status = 'published' AND s0_.deleted_at IS NULL AND c1_.slug IN ('cultures-decouvertes');

SELECT
  s0_.id AS id_0
FROM
  service s0_
  LEFT JOIN category c1_ ON s0_.category_id = c1_.id
WHERE
  s0_.status = ?
  AND s0_.deleted_at IS NULL
  AND c1_.slug IN (?)
GROUP BY
  s0_.id
ORDER BY
  s0_.position ASC,
  s0_.rating_average DESC,
  s0_.reviews_count DESC,
  s0_.id ASC
LIMIT
  12

SELECT s0_.id AS id_0 FROM service s0_ LEFT JOIN category c1_ ON s0_.category_id = c1_.id WHERE s0_.status = 'published' AND s0_.deleted_at IS NULL AND c1_.slug IN ('cultures-decouvertes') GROUP BY s0_.id ORDER BY s0_.position ASC, s0_.rating_average DESC, s0_.reviews_count DESC, s0_.id ASC LIMIT 12;