Symfony Profiler

SELECT
  p0_.id AS id_0
FROM
  project p0_
WHERE
  p0_."begin" >= ?
  AND p0_.is_published = true
ORDER BY
  p0_."begin" ASC
LIMIT
  4

SELECT p0_.id AS id_0 FROM project p0_ WHERE p0_."begin" >= '2026-08-21 00:00:00' AND p0_.is_published = true ORDER BY p0_."begin" ASC LIMIT 4;

SELECT
  p0_.id AS id_0,
  COUNT(p1_.id) AS sclr_1
FROM
  project_tag p0_
  INNER JOIN project_project_tag p2_ ON p0_.id = p2_.project_tag_id
  INNER JOIN project p1_ ON p1_.id = p2_.project_id
WHERE
  p1_.is_published = true
GROUP BY
  p0_.id
ORDER BY
  sclr_1 DESC

SELECT p0_.id AS id_0, COUNT(p1_.id) AS sclr_1 FROM project_tag p0_ INNER JOIN project_project_tag p2_ ON p0_.id = p2_.project_tag_id INNER JOIN project p1_ ON p1_.id = p2_.project_id WHERE p1_.is_published = true GROUP BY p0_.id ORDER BY sclr_1 DESC;