Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.categorie_id AS categorie_id_2
FROM
  sous_categorie s0_
ORDER BY
  s0_.title ASC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.categorie_id AS categorie_id_2 FROM sous_categorie s0_ ORDER BY s0_.title ASC;

SELECT
  d0_.id AS id_0,
  d0_.description AS description_1,
  d0_.salaire AS salaire_2,
  d0_.bloque AS bloque_3,
  d0_.epingle AS epingle_4,
  d0_.etat AS etat_5,
  d0_.created_at AS created_at_6,
  d0_.titre AS titre_7,
  d0_.part AS part_8,
  d0_.tax AS tax_9,
  d0_.total AS total_10,
  d0_.type AS type_11,
  d0_.start_time AS start_time_12,
  d0_.end_time AS end_time_13,
  d0_.end_date_cdi AS end_date_cdi_14,
  d0_.start_period AS start_period_15,
  d0_.end_period AS end_period_16,
  s1_.id AS id_17,
  s1_.title AS title_18,
  d0_.user_id AS user_id_19,
  d0_.souscategorie_id AS souscategorie_id_20,
  s1_.categorie_id AS categorie_id_21
FROM
  demande d0_
  INNER JOIN sous_categorie s1_ ON d0_.souscategorie_id = s1_.id
  INNER JOIN user u2_ ON d0_.user_id = u2_.id
WHERE
  d0_.etat = ?
  AND (
    d0_.start_period >= ?
    OR d0_.end_date_cdi >= ?
  )
  AND d0_.souscategorie_id = ?
ORDER BY
  d0_.created_at DESC

SELECT d0_.id AS id_0, d0_.description AS description_1, d0_.salaire AS salaire_2, d0_.bloque AS bloque_3, d0_.epingle AS epingle_4, d0_.etat AS etat_5, d0_.created_at AS created_at_6, d0_.titre AS titre_7, d0_.part AS part_8, d0_.tax AS tax_9, d0_.total AS total_10, d0_.type AS type_11, d0_.start_time AS start_time_12, d0_.end_time AS end_time_13, d0_.end_date_cdi AS end_date_cdi_14, d0_.start_period AS start_period_15, d0_.end_period AS end_period_16, s1_.id AS id_17, s1_.title AS title_18, d0_.user_id AS user_id_19, d0_.souscategorie_id AS souscategorie_id_20, s1_.categorie_id AS categorie_id_21 FROM demande d0_ INNER JOIN sous_categorie s1_ ON d0_.souscategorie_id = s1_.id INNER JOIN user u2_ ON d0_.user_id = u2_.id WHERE d0_.etat = 'DISPONIBLE' AND (d0_.start_period >= '2025-01-14 00:00:00' OR d0_.end_date_cdi >= '2025-01-14 00:00:00') AND d0_.souscategorie_id = 12 ORDER BY d0_.created_at DESC;