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,
  MIN(s1_.price) AS sclr_1,
  CASE WHEN MIN(s1_.price) IS NULL THEN
    1
  ELSE
    0
  END AS sclr_2
FROM
  service s0_
  LEFT JOIN category c2_ ON s0_.category_id = c2_.id
  LEFT JOIN service_package s1_ ON s0_.id = s1_.service_id
WHERE
  s0_.status = ?
  AND s0_.deleted_at IS NULL
  AND c2_.slug IN (?)
GROUP BY
  s0_.id
ORDER BY
  sclr_2 ASC,
  sclr_1 DESC,
  s0_.id ASC
LIMIT
  12

SELECT s0_.id AS id_0, MIN(s1_.price) AS sclr_1, CASE WHEN MIN(s1_.price) IS NULL THEN 1 ELSE 0 END AS sclr_2 FROM service s0_ LEFT JOIN category c2_ ON s0_.category_id = c2_.id LEFT JOIN service_package s1_ ON s0_.id = s1_.service_id WHERE s0_.status = 'published' AND s0_.deleted_at IS NULL AND c2_.slug IN ('cultures-decouvertes') GROUP BY s0_.id ORDER BY sclr_2 ASC, sclr_1 DESC, s0_.id ASC LIMIT 12;