Symfony Profiler

SELECT
  count(e0_.id) AS sclr_0
FROM
  episode e0_
  INNER JOIN program p1_ ON e0_.program_id = p1_.id
  INNER JOIN radio r2_ ON p1_.radio_id = r2_.id
WHERE
  e0_.published = 1
  AND e0_.reviewed = 1
  AND p1_.published = 1
  AND p1_.reviewed = 1
  AND r2_.published = 1
  AND r2_.reviewed = 1

SELECT count(e0_.id) AS sclr_0 FROM episode e0_ INNER JOIN program p1_ ON e0_.program_id = p1_.id INNER JOIN radio r2_ ON p1_.radio_id = r2_.id WHERE e0_.published = 1 AND e0_.reviewed = 1 AND p1_.published = 1 AND p1_.reviewed = 1 AND r2_.published = 1 AND r2_.reviewed = 1;

SELECT
  count(p0_.id) AS sclr_0
FROM
  program p0_
  INNER JOIN radio r1_ ON p0_.radio_id = r1_.id
WHERE
  p0_.published = 1
  AND p0_.reviewed = 1
  AND r1_.published = 1
  AND r1_.reviewed = 1

SELECT count(p0_.id) AS sclr_0 FROM program p0_ INNER JOIN radio r1_ ON p0_.radio_id = r1_.id WHERE p0_.published = 1 AND p0_.reviewed = 1 AND r1_.published = 1 AND r1_.reviewed = 1;

SELECT
  count(r0_.id) AS sclr_0
FROM
  radio r0_
WHERE
  r0_.published = 1
  AND r0_.reviewed = 1

SELECT count(r0_.id) AS sclr_0 FROM radio r0_ WHERE r0_.published = 1 AND r0_.reviewed = 1;

SELECT
  count(DISTINCT r0_.country) AS sclr_0
FROM
  radio r0_
WHERE
  r0_.published = 1
  AND r0_.reviewed = 1

SELECT count(DISTINCT r0_.country) AS sclr_0 FROM radio r0_ WHERE r0_.published = 1 AND r0_.reviewed = 1;