Symfony Profiler

SELECT
  p.*,
  prg.nom_fr programme,
  prg.nom_ar programme_ar,
  st.nom_fr stat,
  st.nom_ar stat_ar,
  d.nom_fr devise,
  d.nom_ar devise_ar
FROM
  projet p
  INNER JOIN programme prg
  INNER JOIN status st ON st.id = p.status_id
  INNER JOIN devise d ON d.id = p.devise_id
  INNER JOIN projet_commune pc ON pc.projet_id = p.id
  INNER JOIN commune com ON pc.commune_id = com.id
where
  1
group by
  p.id
order by
  p.id desc
limit
  100

SELECT p.*, prg.nom_fr programme, prg.nom_ar programme_ar, st.nom_fr stat, st.nom_ar stat_ar,
                d.nom_fr devise, d.nom_ar devise_ar 
                FROM projet p 
                INNER JOIN programme prg INNER JOIN status st ON st.id = p.status_id 
                INNER JOIN devise d ON d.id = p.devise_id 
                INNER JOIN projet_commune pc ON pc.projet_id = p.id 
                INNER JOIN commune com ON pc.commune_id = com.id 
                where 1  group by p.id order by p.id desc limit 100;

SELECT
  c0_.id AS id_0,
  c0_.nom_fr AS nom_fr_1,
  c0_.nom_ar AS nom_ar_2,
  c0_.nom_en AS nom_en_3,
  c0_.president_fr AS president_fr_4,
  c0_.president_ar AS president_ar_5,
  c0_.secretaire_generale_ar AS secretaire_generale_ar_6,
  c0_.secretaire_generale_fr AS secretaire_generale_fr_7,
  c0_.description_fr AS description_fr_8,
  c0_.description_ar AS description_ar_9,
  c0_.longitude AS longitude_10,
  c0_.latitude AS latitude_11,
  c0_.date_creation AS date_creation_12,
  c0_.date_update AS date_update_13,
  c0_.logo AS logo_14,
  c0_.image_pub AS image_pub_15,
  c0_.superficie AS superficie_16,
  c0_.nbr_habitant AS nbr_habitant_17,
  c0_.email_commune AS email_commune_18,
  c0_.tel_commune AS tel_commune_19,
  c0_.fax_commune AS fax_commune_20,
  c0_.url_commune AS url_commune_21,
  c0_.adresse_commune_ar AS adresse_commune_ar_22,
  c0_.adresse_commune_fr AS adresse_commune_fr_23,
  c0_.page_fb AS page_fb_24,
  c0_.nb_sieges_conseil AS nb_sieges_conseil_25,
  c0_.lib_liste_election_ar AS lib_liste_election_ar_26,
  c0_.lib_liste_election_fr AS lib_liste_election_fr_27,
  c0_.id_domaine AS id_domaine_28,
  c0_.gouvernorat_id AS gouvernorat_id_29
FROM
  commune c0_

SELECT c0_.id AS id_0, c0_.nom_fr AS nom_fr_1, c0_.nom_ar AS nom_ar_2, c0_.nom_en AS nom_en_3, c0_.president_fr AS president_fr_4, c0_.president_ar AS president_ar_5, c0_.secretaire_generale_ar AS secretaire_generale_ar_6, c0_.secretaire_generale_fr AS secretaire_generale_fr_7, c0_.description_fr AS description_fr_8, c0_.description_ar AS description_ar_9, c0_.longitude AS longitude_10, c0_.latitude AS latitude_11, c0_.date_creation AS date_creation_12, c0_.date_update AS date_update_13, c0_.logo AS logo_14, c0_.image_pub AS image_pub_15, c0_.superficie AS superficie_16, c0_.nbr_habitant AS nbr_habitant_17, c0_.email_commune AS email_commune_18, c0_.tel_commune AS tel_commune_19, c0_.fax_commune AS fax_commune_20, c0_.url_commune AS url_commune_21, c0_.adresse_commune_ar AS adresse_commune_ar_22, c0_.adresse_commune_fr AS adresse_commune_fr_23, c0_.page_fb AS page_fb_24, c0_.nb_sieges_conseil AS nb_sieges_conseil_25, c0_.lib_liste_election_ar AS lib_liste_election_ar_26, c0_.lib_liste_election_fr AS lib_liste_election_fr_27, c0_.id_domaine AS id_domaine_28, c0_.gouvernorat_id AS gouvernorat_id_29 FROM commune c0_;

SELECT
  g0_.id AS id_0,
  g0_.id_district AS id_district_1,
  g0_.id_region AS id_region_2,
  g0_.code AS code_3,
  g0_.nom_fr AS nom_fr_4,
  g0_.nom_ar AS nom_ar_5,
  g0_.nom_en AS nom_en_6,
  g0_.longitude AS longitude_7,
  g0_.latitude AS latitude_8,
  g0_.date_creation AS date_creation_9,
  g0_.logo AS logo_10
FROM
  gouvernorat g0_
ORDER BY
  g0_.nom_fr ASC

SELECT g0_.id AS id_0, g0_.id_district AS id_district_1, g0_.id_region AS id_region_2, g0_.code AS code_3, g0_.nom_fr AS nom_fr_4, g0_.nom_ar AS nom_ar_5, g0_.nom_en AS nom_en_6, g0_.longitude AS longitude_7, g0_.latitude AS latitude_8, g0_.date_creation AS date_creation_9, g0_.logo AS logo_10 FROM gouvernorat g0_ ORDER BY g0_.nom_fr ASC;

SELECT
  p0_.id AS id_0,
  p0_.nom_fr AS nom_fr_1,
  p0_.nom_ar AS nom_ar_2,
  p0_.description_fr AS description_fr_3,
  p0_.description_ar AS description_ar_4,
  p0_.logo AS logo_5,
  p0_.adresse_fr AS adresse_fr_6,
  p0_.adresse_ar AS adresse_ar_7,
  p0_.tel AS tel_8,
  p0_.email AS email_9,
  p0_.site_web AS site_web_10
FROM
  partenaire p0_

SELECT p0_.id AS id_0, p0_.nom_fr AS nom_fr_1, p0_.nom_ar AS nom_ar_2, p0_.description_fr AS description_fr_3, p0_.description_ar AS description_ar_4, p0_.logo AS logo_5, p0_.adresse_fr AS adresse_fr_6, p0_.adresse_ar AS adresse_ar_7, p0_.tel AS tel_8, p0_.email AS email_9, p0_.site_web AS site_web_10 FROM partenaire p0_;

SELECT
  e0_.id AS id_0,
  e0_.nom_fr AS nom_fr_1,
  e0_.nom_ar AS nom_ar_2,
  e0_.etat AS etat_3
FROM
  env_intervention e0_

SELECT e0_.id AS id_0, e0_.nom_fr AS nom_fr_1, e0_.nom_ar AS nom_ar_2, e0_.etat AS etat_3 FROM env_intervention e0_;

SELECT
  p0_.id AS id_0,
  p0_.nom_fr AS nom_fr_1,
  p0_.nom_ar AS nom_ar_2,
  p0_.description_fr AS description_fr_3,
  p0_.description_ar AS description_ar_4,
  p0_.budget_tnd AS budget_tnd_5,
  p0_.budget_devise AS budget_devise_6,
  p0_.date_debut AS date_debut_7,
  p0_.date_fin AS date_fin_8,
  p0_.partenaire_id_id AS partenaire_id_id_9,
  p0_.devise_id AS devise_id_10
FROM
  programme p0_

SELECT p0_.id AS id_0, p0_.nom_fr AS nom_fr_1, p0_.nom_ar AS nom_ar_2, p0_.description_fr AS description_fr_3, p0_.description_ar AS description_ar_4, p0_.budget_tnd AS budget_tnd_5, p0_.budget_devise AS budget_devise_6, p0_.date_debut AS date_debut_7, p0_.date_fin AS date_fin_8, p0_.partenaire_id_id AS partenaire_id_id_9, p0_.devise_id AS devise_id_10 FROM programme p0_;

SELECT
  m0_.id AS id_0,
  m0_.nom_fr AS nom_fr_1,
  m0_.nom_ar AS nom_ar_2,
  m0_.etat AS etat_3
FROM
  mod_execution m0_

SELECT m0_.id AS id_0, m0_.nom_fr AS nom_fr_1, m0_.nom_ar AS nom_ar_2, m0_.etat AS etat_3 FROM mod_execution m0_;