Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.salaire AS salaire_3,
  t0.bloque AS bloque_4,
  t0.epingle AS epingle_5,
  t0.etat AS etat_6,
  t0.created_at AS created_at_7,
  t0.titre AS titre_8,
  t0.part AS part_9,
  t0.tax AS tax_10,
  t0.total AS total_11,
  t0.type AS type_12,
  t0.start_time AS start_time_13,
  t0.end_time AS end_time_14,
  t0.end_date_cdi AS end_date_cdi_15,
  t0.start_period AS start_period_16,
  t0.end_period AS end_period_17,
  t0.user_id AS user_id_18,
  t0.souscategorie_id AS souscategorie_id_19
FROM
  demande t0

SELECT t0.id AS id_1, t0.description AS description_2, t0.salaire AS salaire_3, t0.bloque AS bloque_4, t0.epingle AS epingle_5, t0.etat AS etat_6, t0.created_at AS created_at_7, t0.titre AS titre_8, t0.part AS part_9, t0.tax AS tax_10, t0.total AS total_11, t0.type AS type_12, t0.start_time AS start_time_13, t0.end_time AS end_time_14, t0.end_date_cdi AS end_date_cdi_15, t0.start_period AS start_period_16, t0.end_period AS end_period_17, t0.user_id AS user_id_18, t0.souscategorie_id AS souscategorie_id_19 FROM demande t0;

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
WHERE
  d0_.etat = ?
  AND d0_.epingle = ?
  AND (
    d0_.start_period >= ?
    OR d0_.end_date_cdi >= ?
  )
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 WHERE d0_.etat = 'DISPONIBLE' AND d0_.epingle = 1 AND (d0_.start_period >= '2024-12-24 02:23:45' OR d0_.end_date_cdi >= '2024-12-24 02:23:45') ORDER BY d0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  categorie t0

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categorie t0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.categorie_id AS categorie_id_3
FROM
  sous_categorie t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.categorie_id AS categorie_id_3 FROM sous_categorie t0;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.created_at AS created_at_5,
  t0.username AS username_6,
  t0.token AS token_7,
  t0.lastname AS lastname_8,
  t0.phone AS phone_9,
  t0.address AS address_10,
  t0.ville AS ville_11,
  t0.reset_token AS reset_token_12,
  t0.naissance AS naissance_13,
  t0.experience AS experience_14,
  t0.sociale AS sociale_15,
  t0.bancaire AS bancaire_16,
  t0.cv AS cv_17,
  t0.identite AS identite_18,
  t0.logo AS logo_19,
  t0.etablissement AS etablissement_20,
  t0.a_propos AS a_propos_21,
  t0.matricule AS matricule_22,
  t0.is_blocked AS is_blocked_23,
  t0.enabled AS enabled_24,
  t25.id AS id_26,
  t25.image_name AS image_name_27,
  t25.updated_at AS updated_at_28,
  t25.user_images_id AS user_images_id_29
FROM
  user t0
  LEFT JOIN user_image t25 ON t25.user_images_id = t0.id

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.username AS username_6, t0.token AS token_7, t0.lastname AS lastname_8, t0.phone AS phone_9, t0.address AS address_10, t0.ville AS ville_11, t0.reset_token AS reset_token_12, t0.naissance AS naissance_13, t0.experience AS experience_14, t0.sociale AS sociale_15, t0.bancaire AS bancaire_16, t0.cv AS cv_17, t0.identite AS identite_18, t0.logo AS logo_19, t0.etablissement AS etablissement_20, t0.a_propos AS a_propos_21, t0.matricule AS matricule_22, t0.is_blocked AS is_blocked_23, t0.enabled AS enabled_24, t25.id AS id_26, t25.image_name AS image_name_27, t25.updated_at AS updated_at_28, t25.user_images_id AS user_images_id_29 FROM user t0 LEFT JOIN user_image t25 ON t25.user_images_id = t0.id;