Symfony Profiler

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\ChampScientifique';

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  champ_scientifique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM champ_scientifique t0 WHERE t0.id = 1;

SELECT
  count(DISTINCT d0_.id) AS sclr_0
FROM
  demandeur d0_
WHERE
  d0_.etat_id = ?

SELECT count(DISTINCT d0_.id) AS sclr_0 FROM demandeur d0_ WHERE d0_.etat_id = 5;

SELECT
  d0_.id AS id_0,
  d0_.chrono AS chrono_1,
  d0_.nom AS nom_2,
  d0_.prenom AS prenom_3,
  d0_.fonction AS fonction_4,
  d0_.autre_poste AS autre_poste_5,
  d0_.gestion_contrat AS gestion_contrat_6,
  d0_.budget AS budget_7,
  d0_.intitule AS intitule_8,
  d0_.date_prise_de_fonction AS date_prise_de_fonction_9,
  d0_.duree_contrat AS duree_contrat_10,
  d0_.masse_salariale AS masse_salariale_11,
  d0_.intitule_du_poste AS intitule_du_poste_12,
  d0_.categorie AS categorie_13,
  d0_.quotite AS quotite_14,
  d0_.type_contrat AS type_contrat_15,
  d0_.site_web_labo AS site_web_labo_16,
  d0_.fonction_encadrement AS fonction_encadrement_17,
  d0_.description AS description_18,
  d0_.domaine_recherche AS domaine_recherche_19,
  d0_.competences AS competences_20,
  d0_.connaissances AS connaissances_21,
  d0_.diplome_requis AS diplome_requis_22,
  d0_.experience AS experience_23,
  d0_.date_limite_candidature AS date_limite_candidature_24,
  d0_.telephone AS telephone_25,
  d0_.email AS email_26,
  d0_.date_soumission AS date_soumission_27,
  d0_.date_validation AS date_validation_28,
  d0_.created_at AS created_at_29,
  d0_.numero_contrat_recherche AS numero_contrat_recherche_30,
  d0_.date_retour_admin AS date_retour_admin_31,
  d0_.retour_admin AS retour_admin_32,
  d0_.remuneration AS remuneration_33,
  d0_.date_completion AS date_completion_34,
  d0_.site_web_personnel AS site_web_personnel_35,
  d0_.type_duree_contrat AS type_duree_contrat_36,
  d0_.message_pour_gestionnaire AS message_pour_gestionnaire_37,
  d0_.bloquage_audition AS bloquage_audition_38,
  d0_.bloquage_rang AS bloquage_rang_39,
  d0_.type_poste_id AS type_poste_id_40,
  d0_.site_affectation_id AS site_affectation_id_41,
  d0_.labo_affectation_id AS labo_affectation_id_42,
  d0_.user_id AS user_id_43,
  d0_.champ_scientifique_id AS champ_scientifique_id_44,
  d0_.etat_id AS etat_id_45
FROM
  demandeur d0_
WHERE
  d0_.etat_id = ?
  AND d0_.id IN (?)
ORDER BY
  d0_.date_validation DESC

SELECT d0_.id AS id_0, d0_.chrono AS chrono_1, d0_.nom AS nom_2, d0_.prenom AS prenom_3, d0_.fonction AS fonction_4, d0_.autre_poste AS autre_poste_5, d0_.gestion_contrat AS gestion_contrat_6, d0_.budget AS budget_7, d0_.intitule AS intitule_8, d0_.date_prise_de_fonction AS date_prise_de_fonction_9, d0_.duree_contrat AS duree_contrat_10, d0_.masse_salariale AS masse_salariale_11, d0_.intitule_du_poste AS intitule_du_poste_12, d0_.categorie AS categorie_13, d0_.quotite AS quotite_14, d0_.type_contrat AS type_contrat_15, d0_.site_web_labo AS site_web_labo_16, d0_.fonction_encadrement AS fonction_encadrement_17, d0_.description AS description_18, d0_.domaine_recherche AS domaine_recherche_19, d0_.competences AS competences_20, d0_.connaissances AS connaissances_21, d0_.diplome_requis AS diplome_requis_22, d0_.experience AS experience_23, d0_.date_limite_candidature AS date_limite_candidature_24, d0_.telephone AS telephone_25, d0_.email AS email_26, d0_.date_soumission AS date_soumission_27, d0_.date_validation AS date_validation_28, d0_.created_at AS created_at_29, d0_.numero_contrat_recherche AS numero_contrat_recherche_30, d0_.date_retour_admin AS date_retour_admin_31, d0_.retour_admin AS retour_admin_32, d0_.remuneration AS remuneration_33, d0_.date_completion AS date_completion_34, d0_.site_web_personnel AS site_web_personnel_35, d0_.type_duree_contrat AS type_duree_contrat_36, d0_.message_pour_gestionnaire AS message_pour_gestionnaire_37, d0_.bloquage_audition AS bloquage_audition_38, d0_.bloquage_rang AS bloquage_rang_39, d0_.type_poste_id AS type_poste_id_40, d0_.site_affectation_id AS site_affectation_id_41, d0_.labo_affectation_id AS labo_affectation_id_42, d0_.user_id AS user_id_43, d0_.champ_scientifique_id AS champ_scientifique_id_44, d0_.etat_id AS etat_id_45 FROM demandeur d0_ WHERE d0_.etat_id = 5 AND d0_.id IN (82, 80, 79, 72, 73, 71, 69, 70, 68, 67) ORDER BY d0_.date_validation DESC;

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.date_validation AS date_validation_1
FROM
  demandeur d0_
WHERE
  d0_.etat_id = ?
ORDER BY
  d0_.date_validation DESC
LIMIT
  10

SELECT DISTINCT d0_.id AS id_0, d0_.date_validation AS date_validation_1 FROM demandeur d0_ WHERE d0_.etat_id = 5 ORDER BY d0_.date_validation DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  type_poste t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type_poste t0;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  champ_scientifique t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM champ_scientifique t0;