Symfony Profiler

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

SELECT s0_.id AS id_0, s0_.location AS location_1, s0_.$location_optional AS location_optional_2, s0_.jobType AS jobType_3, s0_.companyName AS companyName_4, s0_.description AS description_5, s0_.logoUrl AS logoUrl_6, s0_.startingDate AS startingDate_7, s0_.endDate AS endDate_8, s0_.companyType AS companyType_9, s0_.jobUrl AS jobUrl_10, s0_.categories AS categories_11, s0_.tags AS tags_12, s0_.applyTarget AS applyTarget_13, s0_.history AS history_14, s0_.lastChangeUser AS lastChangeUser_15, s0_.lastModified AS lastModified_16, s0_.createdAt AS createdAt_17 FROM sp_job_listings s0_ WHERE '2026-02-26 23:47:02' BETWEEN s0_.startingDate AND s0_.endDate ORDER BY s0_.startingDate DESC;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  sp_job_listings s0_

SELECT COUNT(s0_.id) AS sclr_0 FROM sp_job_listings s0_;