Symfony Profiler

SELECT
  DISTINCT p0_.location AS location_0
FROM
  project p1_
  INNER JOIN project_details p0_ ON p1_.id = p0_.project_id
WHERE
  p1_.is_published = true
  AND p0_.location IS NOT NULL
  AND p0_.location <> ''
ORDER BY
  p0_.location ASC

SELECT DISTINCT p0_.location AS location_0 FROM project p1_ INNER JOIN project_details p0_ ON p1_.id = p0_.project_id WHERE p1_.is_published = true AND p0_.location IS NOT NULL AND p0_.location <> '' ORDER BY p0_.location ASC;

SELECT
  p0_.id AS id_0,
  COALESCE(
    CAST(
      t1_.content AS VARCHAR(255)
    ),
    p0_.name
  ) AS name_1,
  p0_.created_at AS created_at_2,
  p0_.updated_at AS updated_at_3
FROM
  project_tag p0_
  LEFT JOIN project_tag_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'name'
  AND t1_.object_id = p0_.id
ORDER BY
  COALESCE(
    CAST(
      t1_.content AS VARCHAR(255)
    ),
    p0_.name
  ) ASC

SELECT p0_.id AS id_0, COALESCE(CAST(t1_.content AS VARCHAR(255)), p0_.name) AS name_1, p0_.created_at AS created_at_2, p0_.updated_at AS updated_at_3 FROM project_tag p0_ LEFT JOIN project_tag_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_id = p0_.id ORDER BY COALESCE(CAST(t1_.content AS VARCHAR(255)), p0_.name) ASC;

SELECT
  count(DISTINCT p2_.id) AS sclr_0
FROM
  project p2_
  INNER JOIN project_details p3_ ON p2_.id = p3_.project_id
  INNER JOIN project_ui_config p4_ ON p2_.id = p4_.project_id
  LEFT JOIN project_project_tag p5_ ON p2_.id = p5_.project_id
  LEFT JOIN project_tag p0_ ON p0_.id = p5_.project_tag_id
  LEFT JOIN project_tag_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'name'
  AND t1_.object_id = p0_.id
WHERE
  p2_."begin" >= ?
  AND p2_.is_published = true

SELECT count(DISTINCT p2_.id) AS sclr_0 FROM project p2_ INNER JOIN project_details p3_ ON p2_.id = p3_.project_id INNER JOIN project_ui_config p4_ ON p2_.id = p4_.project_id LEFT JOIN project_project_tag p5_ ON p2_.id = p5_.project_id LEFT JOIN project_tag p0_ ON p0_.id = p5_.project_tag_id LEFT JOIN project_tag_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_id = p0_.id WHERE p2_."begin" >= '2026-08-21 00:00:00' AND p2_.is_published = true;

SELECT
  DISTINCT p2_.id AS id_0,
  p2_."begin" AS begin_1
FROM
  project p2_
  INNER JOIN project_details p3_ ON p2_.id = p3_.project_id
  INNER JOIN project_ui_config p4_ ON p2_.id = p4_.project_id
  LEFT JOIN project_project_tag p5_ ON p2_.id = p5_.project_id
  LEFT JOIN project_tag p0_ ON p0_.id = p5_.project_tag_id
  LEFT JOIN project_tag_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'name'
  AND t1_.object_id = p0_.id
WHERE
  p2_."begin" >= ?
  AND p2_.is_published = true
ORDER BY
  p2_."begin" ASC
LIMIT
  10

SELECT DISTINCT p2_.id AS id_0, p2_."begin" AS begin_1 FROM project p2_ INNER JOIN project_details p3_ ON p2_.id = p3_.project_id INNER JOIN project_ui_config p4_ ON p2_.id = p4_.project_id LEFT JOIN project_project_tag p5_ ON p2_.id = p5_.project_id LEFT JOIN project_tag p0_ ON p0_.id = p5_.project_tag_id LEFT JOIN project_tag_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_id = p0_.id WHERE p2_."begin" >= '2026-08-21 00:00:00' AND p2_.is_published = true ORDER BY p2_."begin" ASC LIMIT 10;