Symfony Profiler

SELECT
  l0_.type AS type_0,
  l0_.locale AS locale_1,
  l0_.version AS version_2,
  l0_.title AS title_3,
  l0_.content AS content_4,
  l0_.change_summary AS change_summary_5,
  l0_.published_at AS published_at_6,
  l0_.effective_at AS effective_at_7,
  l0_.requires_reacceptance AS requires_reacceptance_8,
  l0_.id AS id_9,
  l0_.created_at AS created_at_10,
  l0_.updated_at AS updated_at_11
FROM
  legal_document l0_
WHERE
  l0_.type = ?
  AND l0_.locale = ?
  AND l0_.published_at IS NOT NULL
  AND l0_.effective_at <= ?
ORDER BY
  l0_.effective_at DESC,
  l0_.published_at DESC
LIMIT
  1

SELECT l0_.type AS type_0, l0_.locale AS locale_1, l0_.version AS version_2, l0_.title AS title_3, l0_.content AS content_4, l0_.change_summary AS change_summary_5, l0_.published_at AS published_at_6, l0_.effective_at AS effective_at_7, l0_.requires_reacceptance AS requires_reacceptance_8, l0_.id AS id_9, l0_.created_at AS created_at_10, l0_.updated_at AS updated_at_11 FROM legal_document l0_ WHERE l0_.type = 'legal_notice' AND l0_.locale = 'fr' AND l0_.published_at IS NOT NULL AND l0_.effective_at <= '2026-09-22 14:03:48' ORDER BY l0_.effective_at DESC, l0_.published_at DESC LIMIT 1;