Symfony Profiler

SELECT
  c0_.city AS city_0,
  COUNT(c0_.id) AS sclr_1
FROM
  cvs_jobs c0_
  LEFT JOIN cvs_enterprises c1_ ON c0_.enterprise_id = c1_.id
WHERE
  c0_.online = ?
  AND (
    (
      c1_.id IS NULL
      OR c1_.online = ?
    )
  )
  AND c0_.city IS NOT NULL
  AND c0_.city <> ''
GROUP BY
  c0_.city
ORDER BY
  sclr_1 DESC

SELECT c0_.city AS city_0, COUNT(c0_.id) AS sclr_1 FROM cvs_jobs c0_ LEFT JOIN cvs_enterprises c1_ ON c0_.enterprise_id = c1_.id WHERE c0_.online = 1 AND ((c1_.id IS NULL OR c1_.online = 1)) AND c0_.city IS NOT NULL AND c0_.city <> '' GROUP BY c0_.city ORDER BY sclr_1 DESC;

SELECT
  c0_.category AS category_0,
  COUNT(c0_.id) AS sclr_1
FROM
  cvs_jobs c0_
  LEFT JOIN cvs_enterprises c1_ ON c0_.enterprise_id = c1_.id
WHERE
  c0_.online = ?
  AND (
    (
      c1_.id IS NULL
      OR c1_.online = ?
    )
  )
  AND c0_.category IS NOT NULL
  AND c0_.category <> ''
GROUP BY
  c0_.category
ORDER BY
  sclr_1 DESC

SELECT c0_.category AS category_0, COUNT(c0_.id) AS sclr_1 FROM cvs_jobs c0_ LEFT JOIN cvs_enterprises c1_ ON c0_.enterprise_id = c1_.id WHERE c0_.online = 1 AND ((c1_.id IS NULL OR c1_.online = 1)) AND c0_.category IS NOT NULL AND c0_.category <> '' GROUP BY c0_.category ORDER BY sclr_1 DESC;