Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.location AS location_1,
  a0_.$location_optional AS location_optional_2,
  a0_.jobType AS jobType_3,
  a0_.companyName AS companyName_4,
  a0_.description AS description_5,
  a0_.logoUrl AS logoUrl_6,
  a0_.startingDate AS startingDate_7,
  a0_.endDate AS endDate_8,
  a0_.companyType AS companyType_9,
  a0_.jobUrl AS jobUrl_10,
  a0_.categories AS categories_11,
  a0_.tags AS tags_12,
  a0_.applyTarget AS applyTarget_13,
  a0_.history AS history_14,
  a0_.lastChangeUser AS lastChangeUser_15,
  a0_.lastModified AS lastModified_16,
  a0_.createdAt AS createdAt_17
FROM
  aaa_sp_jobs a0_
WHERE
  ? BETWEEN a0_.startingDate
  AND a0_.endDate
ORDER BY
  a0_.startingDate DESC

SELECT a0_.id AS id_0, a0_.location AS location_1, a0_.$location_optional AS location_optional_2, a0_.jobType AS jobType_3, a0_.companyName AS companyName_4, a0_.description AS description_5, a0_.logoUrl AS logoUrl_6, a0_.startingDate AS startingDate_7, a0_.endDate AS endDate_8, a0_.companyType AS companyType_9, a0_.jobUrl AS jobUrl_10, a0_.categories AS categories_11, a0_.tags AS tags_12, a0_.applyTarget AS applyTarget_13, a0_.history AS history_14, a0_.lastChangeUser AS lastChangeUser_15, a0_.lastModified AS lastModified_16, a0_.createdAt AS createdAt_17 FROM aaa_sp_jobs a0_ WHERE '2025-12-29 00:54:50' BETWEEN a0_.startingDate AND a0_.endDate ORDER BY a0_.startingDate DESC;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  aaa_sp_jobs a0_

SELECT COUNT(a0_.id) AS sclr_0 FROM aaa_sp_jobs a0_;