Symfony Profiler

SELECT
  count(p0_.id) AS sclr_0
FROM
  point_of_interests_pictures p0_
  INNER JOIN point_of_interest p1_ ON p0_.point_of_interest_id = p1_.id
  INNER JOIN revision r2_ ON p1_.id = r2_.point_of_interest_id
  AND (
    r2_.main = 1
    AND r2_.point_of_interest_id = p1_.id
    AND r2_.deleted_at IS NULL
  )
WHERE
  p0_.validated_at IS NULL
  AND p0_.type = ?

SELECT count(p0_.id) AS sclr_0 FROM point_of_interests_pictures p0_ INNER JOIN point_of_interest p1_ ON p0_.point_of_interest_id = p1_.id INNER JOIN revision r2_ ON p1_.id = r2_.point_of_interest_id AND (r2_.main = 1 AND r2_.point_of_interest_id = p1_.id AND r2_.deleted_at IS NULL) WHERE p0_.validated_at IS NULL AND p0_.type = 'uncertified';

SELECT
  count(c0_.id) AS sclr_0
FROM
  comment c0_
  INNER JOIN v_uncertified_comment v1_ ON (v1_.id = c0_.id)
WHERE
  c0_.type IN (
    'comment', 'point_of_interest_comment',
    'trip_comment'
  )
ORDER BY
  c0_.created_at DESC

SELECT count(c0_.id) AS sclr_0 FROM comment c0_ INNER JOIN v_uncertified_comment v1_ ON (v1_.id = c0_.id) WHERE c0_.type IN ('comment', 'point_of_interest_comment', 'trip_comment') ORDER BY c0_.created_at DESC;

SELECT
  count(r1.point_of_interest_id) AS count_poi
FROM
  revision r1
  INNER JOIN point_of_interest poi on r1.point_of_interest_id = poi.id
WHERE
  r1.deleted_at IS NULL
  AND r1.id IN (
    SELECT
      MAX(r.id) AS sclr_1
    FROM
      revision r
    WHERE
      r.point_of_interest_id = r1.point_of_interest_id
  )
  AND r1.main = 0
  AND poi.deleted_at IS NULL
  AND poi.draft = 0;

SELECT count(r1.point_of_interest_id) AS count_poi
            FROM revision r1
            INNER JOIN point_of_interest poi on r1.point_of_interest_id = poi.id
        WHERE r1.deleted_at IS NULL
          AND r1.id IN (SELECT MAX(r.id) AS sclr_1 FROM revision r WHERE r.point_of_interest_id = r1.point_of_interest_id)
          AND r1.main = 0
          AND poi.deleted_at IS NULL
          AND poi.draft = 0
            ;
        ;

SELECT
  count(a0_.id) AS sclr_0
FROM
  activity a0_
WHERE
  a0_.certified = 0
  AND a0_.deleted_at IS NULL

SELECT count(a0_.id) AS sclr_0 FROM activity a0_ WHERE a0_.certified = 0 AND a0_.deleted_at IS NULL;

SELECT
  count(o0_.id) AS sclr_0
FROM
  ownership_request o0_
  INNER JOIN point_of_interest p1_ ON o0_.point_of_interest_id = p1_.id
  INNER JOIN revision r2_ ON p1_.id = r2_.point_of_interest_id
  AND (
    r2_.main = 1
    AND p1_.id = r2_.point_of_interest_id
    AND r2_.deleted_at IS NULL
  )
WHERE
  o0_.accepted_at IS NULL
  AND o0_.refused_at IS NULL

SELECT count(o0_.id) AS sclr_0 FROM ownership_request o0_ INNER JOIN point_of_interest p1_ ON o0_.point_of_interest_id = p1_.id INNER JOIN revision r2_ ON p1_.id = r2_.point_of_interest_id AND (r2_.main = 1 AND p1_.id = r2_.point_of_interest_id AND r2_.deleted_at IS NULL) WHERE o0_.accepted_at IS NULL AND o0_.refused_at IS NULL;