Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.objectif AS objectif_2,
  p0_.date_debut AS date_debut_3,
  p0_.date_fin AS date_fin_4,
  p0_.description AS description_5,
  p0_.etat AS etat_6,
  p0_.statut AS statut_7,
  p0_.domaine_recherche AS domaine_recherche_8,
  p0_.image AS image_9,
  p0_.user_id AS user_id_10,
  p0_.directeur_id AS directeur_id_11,
  p0_.theme_id AS theme_id_12,
  p0_.structure_id AS structure_id_13
FROM
  projet p0_
WHERE
  p0_.etat = 2
  AND p0_.date_fin >= ?
ORDER BY
  p0_.id DESC
LIMIT
  4

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.objectif AS objectif_2, p0_.date_debut AS date_debut_3, p0_.date_fin AS date_fin_4, p0_.description AS description_5, p0_.etat AS etat_6, p0_.statut AS statut_7, p0_.domaine_recherche AS domaine_recherche_8, p0_.image AS image_9, p0_.user_id AS user_id_10, p0_.directeur_id AS directeur_id_11, p0_.theme_id AS theme_id_12, p0_.structure_id AS structure_id_13 FROM projet p0_ WHERE p0_.etat = 2 AND p0_.date_fin >= '2025-10-15 17:57:47' ORDER BY p0_.id DESC LIMIT 4;

SELECT
  a0_.id AS id_0,
  a0_.image_nom AS image_nom_1,
  a0_.description AS description_2,
  a0_.ordre AS ordre_3,
  a0_.date_fin AS date_fin_4,
  a0_.date_debut AS date_debut_5
FROM
  actualite a0_
WHERE
  a0_.date_fin >= ?
ORDER BY
  a0_.ordre ASC

SELECT a0_.id AS id_0, a0_.image_nom AS image_nom_1, a0_.description AS description_2, a0_.ordre AS ordre_3, a0_.date_fin AS date_fin_4, a0_.date_debut AS date_debut_5 FROM actualite a0_ WHERE a0_.date_fin >= '2025-10-15 17:57:47' ORDER BY a0_.ordre ASC;

SELECT
  count(*) as nbr
FROM
  projet

SELECT  count(*) as nbr  FROM projet ;

SELECT
  t0.id AS id_1,
  t0.cin AS cin_2,
  t0.date_naissance AS date_naissance_3,
  t0.grade AS grade_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.email AS email_7,
  t0.photo AS photo_8,
  t0.specialite AS specialite_9,
  t0.biography AS biography_10,
  t0.linkedin AS linkedin_11,
  t0.orcid AS orcid_12,
  t0.p_google AS p_google_13,
  t0.p_scopus AS p_scopus_14,
  t0.fonction AS fonction_15,
  t0.p_web_science AS p_web_science_16,
  t0.resarchgate AS resarchgate_17,
  t0.masteres_recherches AS masteres_recherches_18,
  t0.theses_doctorat AS theses_doctorat_19,
  t0.date_debut AS date_debut_20,
  t0.date_fin AS date_fin_21,
  t0.projet_nationaux_iternationaux AS projet_nationaux_iternationaux_22,
  t0.brevet_nationaux_internationaux AS brevet_nationaux_internationaux_23,
  t0.autre_activites AS autre_activites_24,
  t0.etablissement_enseignement AS etablissement_enseignement_25,
  t0.etat_cin AS etat_cin_26,
  t0.etat_naissance AS etat_naissance_27,
  t0.etat_phone AS etat_phone_28,
  t0.etablissement_id AS etablissement_id_29,
  t0.user_id AS user_id_30,
  t0.structure_id AS structure_id_31
FROM
  chercheur t0

SELECT t0.id AS id_1, t0.cin AS cin_2, t0.date_naissance AS date_naissance_3, t0.grade AS grade_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.email AS email_7, t0.photo AS photo_8, t0.specialite AS specialite_9, t0.biography AS biography_10, t0.linkedin AS linkedin_11, t0.orcid AS orcid_12, t0.p_google AS p_google_13, t0.p_scopus AS p_scopus_14, t0.fonction AS fonction_15, t0.p_web_science AS p_web_science_16, t0.resarchgate AS resarchgate_17, t0.masteres_recherches AS masteres_recherches_18, t0.theses_doctorat AS theses_doctorat_19, t0.date_debut AS date_debut_20, t0.date_fin AS date_fin_21, t0.projet_nationaux_iternationaux AS projet_nationaux_iternationaux_22, t0.brevet_nationaux_internationaux AS brevet_nationaux_internationaux_23, t0.autre_activites AS autre_activites_24, t0.etablissement_enseignement AS etablissement_enseignement_25, t0.etat_cin AS etat_cin_26, t0.etat_naissance AS etat_naissance_27, t0.etat_phone AS etat_phone_28, t0.etablissement_id AS etablissement_id_29, t0.user_id AS user_id_30, t0.structure_id AS structure_id_31 FROM chercheur t0;

SELECT
  count(*) as nbr
FROM
  publication

SELECT  count(*) as nbr  FROM publication ;

SELECT
  count(*) as nbr
FROM
  structure_recherche

SELECT  count(*) as nbr  FROM structure_recherche ;

SELECT
  t0.id AS id_1,
  t0.nom_long AS nom_long_2,
  t0.nom_court AS nom_court_3,
  t0.nom_arabe AS nom_arabe_4,
  t0.type AS type_5,
  t0.etat AS etat_6,
  t0.adresse AS adresse_7,
  t0.email AS email_8,
  t0.site_web AS site_web_9,
  t0.logo AS logo_10,
  t0.description AS description_11,
  t0.code AS code_12,
  t0.image1 AS image1_13,
  t0.image2 AS image2_14,
  t0.image3 AS image3_15,
  t0.doc_pdf AS doc_pdf_16,
  t0.nom_doc_pdf AS nom_doc_pdf_17,
  t0.responsable_id AS responsable_id_18,
  t0.etablissement_id AS etablissement_id_19,
  t0.domaine_id AS domaine_id_20
FROM
  structure_recherche t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_long AS nom_long_2, t0.nom_court AS nom_court_3, t0.nom_arabe AS nom_arabe_4, t0.type AS type_5, t0.etat AS etat_6, t0.adresse AS adresse_7, t0.email AS email_8, t0.site_web AS site_web_9, t0.logo AS logo_10, t0.description AS description_11, t0.code AS code_12, t0.image1 AS image1_13, t0.image2 AS image2_14, t0.image3 AS image3_15, t0.doc_pdf AS doc_pdf_16, t0.nom_doc_pdf AS nom_doc_pdf_17, t0.responsable_id AS responsable_id_18, t0.etablissement_id AS etablissement_id_19, t0.domaine_id AS domaine_id_20 FROM structure_recherche t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.nom_long AS nom_long_2,
  t0.nom_court AS nom_court_3,
  t0.nom_arabe AS nom_arabe_4,
  t0.type AS type_5,
  t0.etat AS etat_6,
  t0.adresse AS adresse_7,
  t0.email AS email_8,
  t0.site_web AS site_web_9,
  t0.logo AS logo_10,
  t0.description AS description_11,
  t0.code AS code_12,
  t0.image1 AS image1_13,
  t0.image2 AS image2_14,
  t0.image3 AS image3_15,
  t0.doc_pdf AS doc_pdf_16,
  t0.nom_doc_pdf AS nom_doc_pdf_17,
  t0.responsable_id AS responsable_id_18,
  t0.etablissement_id AS etablissement_id_19,
  t0.domaine_id AS domaine_id_20
FROM
  structure_recherche t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_long AS nom_long_2, t0.nom_court AS nom_court_3, t0.nom_arabe AS nom_arabe_4, t0.type AS type_5, t0.etat AS etat_6, t0.adresse AS adresse_7, t0.email AS email_8, t0.site_web AS site_web_9, t0.logo AS logo_10, t0.description AS description_11, t0.code AS code_12, t0.image1 AS image1_13, t0.image2 AS image2_14, t0.image3 AS image3_15, t0.doc_pdf AS doc_pdf_16, t0.nom_doc_pdf AS nom_doc_pdf_17, t0.responsable_id AS responsable_id_18, t0.etablissement_id AS etablissement_id_19, t0.domaine_id AS domaine_id_20 FROM structure_recherche t0 WHERE t0.id = 12;