Symfony Profiler

SELECT
  count(a0_.id) AS sclr_0
FROM
  acteur a0_
  LEFT JOIN departement d1_ ON a0_.departement_id = d1_.id
  LEFT JOIN region r2_ ON d1_.region_id = r2_.id

SELECT count(a0_.id) AS sclr_0 FROM acteur a0_ LEFT JOIN departement d1_ ON a0_.departement_id = d1_.id LEFT JOIN region r2_ ON d1_.region_id = r2_.id;

SELECT
  a0_.id AS id_0,
  a0_.logo AS logo_1,
  a0_.code AS code_2,
  a0_.date_collecte AS date_collecte_3,
  a0_.denomination AS denomination_4,
  a0_.sigle AS sigle_5,
  a0_.latitude AS latitude_6,
  a0_.longitude AS longitude_7,
  a0_.commune AS commune_8,
  a0_.annee_creation AS annee_creation_9,
  a0_.numero_rccm AS numero_rccm_10,
  a0_.numero_ncc AS numero_ncc_11,
  a0_.telephone AS telephone_12,
  a0_.email AS email_13,
  a0_.site_web AS site_web_14,
  a0_.description AS description_15,
  a0_.maillon AS maillon_16,
  a0_.status AS status_17,
  a0_.qualification AS qualification_18,
  a0_.score AS score_19,
  a0_.sous_prefecture_id AS sous_prefecture_id_20,
  a0_.departement_id AS departement_id_21,
  a0_.statut_juridique_id AS statut_juridique_id_22,
  a0_.type_acteur_id AS type_acteur_id_23
FROM
  acteur a0_
  LEFT JOIN departement d1_ ON a0_.departement_id = d1_.id
  LEFT JOIN region r2_ ON d1_.region_id = r2_.id
LIMIT
  12
OFFSET
  456

SELECT a0_.id AS id_0, a0_.logo AS logo_1, a0_.code AS code_2, a0_.date_collecte AS date_collecte_3, a0_.denomination AS denomination_4, a0_.sigle AS sigle_5, a0_.latitude AS latitude_6, a0_.longitude AS longitude_7, a0_.commune AS commune_8, a0_.annee_creation AS annee_creation_9, a0_.numero_rccm AS numero_rccm_10, a0_.numero_ncc AS numero_ncc_11, a0_.telephone AS telephone_12, a0_.email AS email_13, a0_.site_web AS site_web_14, a0_.description AS description_15, a0_.maillon AS maillon_16, a0_.status AS status_17, a0_.qualification AS qualification_18, a0_.score AS score_19, a0_.sous_prefecture_id AS sous_prefecture_id_20, a0_.departement_id AS departement_id_21, a0_.statut_juridique_id AS statut_juridique_id_22, a0_.type_acteur_id AS type_acteur_id_23 FROM acteur a0_ LEFT JOIN departement d1_ ON a0_.departement_id = d1_.id LEFT JOIN region r2_ ON d1_.region_id = r2_.id LIMIT 12 OFFSET 456;

SELECT
  DISTINCT dist.id,
  dist.nom
FROM
  district dist
ORDER BY
  dist.nom

SELECT DISTINCT dist.id, dist.nom FROM district dist ORDER BY dist.nom;

SELECT
  DISTINCT r.id,
  r.nom,
  r.district_id
FROM
  region r
ORDER BY
  r.nom

SELECT DISTINCT r.id, r.nom, r.district_id FROM region r ORDER BY r.nom;

SELECT
  DISTINCT dp.id,
  dp.nom,
  dp.region_id,
  r.district_id
FROM
  departement dp
  JOIN region r ON dp.region_id = r.id
ORDER BY
  dp.nom

SELECT DISTINCT dp.id, dp.nom, dp.region_id, r.district_id FROM departement dp JOIN region r ON dp.region_id = r.id ORDER BY dp.nom;

SELECT
  DISTINCT sp.id,
  sp.nom,
  sp.departement_id,
  dp.region_id,
  r.district_id
FROM
  sous_prefecture sp
  JOIN departement dp ON sp.departement_id = dp.id
  JOIN region r ON dp.region_id = r.id
ORDER BY
  sp.nom

SELECT DISTINCT sp.id, sp.nom, sp.departement_id, dp.region_id, r.district_id FROM sous_prefecture sp JOIN departement dp ON sp.departement_id = dp.id JOIN region r ON dp.region_id = r.id ORDER BY sp.nom;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3
FROM
  type_acteur t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM type_acteur t0;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  role_principal t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM role_principal t0;

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

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

SELECT
  a.id,
  a.denomination,
  a.commune,
  a.code,
  a.sigle
FROM
  acteur a
WHERE
  a.status = "Actif"

SELECT a.id, a.denomination, a.commune, a.code, a.sigle FROM acteur a WHERE a.status = "Actif";

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0
  INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id
WHERE
  acteur_filieres.acteur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = 457;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0
  INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id
WHERE
  acteur_filieres.acteur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = 458;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0
  INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id
WHERE
  acteur_filieres.acteur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = 459;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0
  INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id
WHERE
  acteur_filieres.acteur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = 460;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0
  INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id
WHERE
  acteur_filieres.acteur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = 461;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0
  INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id
WHERE
  acteur_filieres.acteur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = 462;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0
  INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id
WHERE
  acteur_filieres.acteur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = 463;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0
  INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id
WHERE
  acteur_filieres.acteur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = 464;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0
  INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id
WHERE
  acteur_filieres.acteur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = 465;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0
  INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id
WHERE
  acteur_filieres.acteur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = 466;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0
  INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id
WHERE
  acteur_filieres.acteur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = 467;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4
FROM
  filieres t0
  INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id
WHERE
  acteur_filieres.acteur_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4 FROM filieres t0 INNER JOIN acteur_filieres ON t0.id = acteur_filieres.filieres_id WHERE acteur_filieres.acteur_id = 468;