Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.duree AS duree_3,
  t0.description AS description_4,
  t0.montant AS montant_5,
  t0.sous_domaine AS sous_domaine_6,
  t0.coordonnateur_id AS coordonnateur_id_7
FROM
  programme t0
WHERE
  t0.sous_domaine = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.duree AS duree_3, t0.description AS description_4, t0.montant AS montant_5, t0.sous_domaine AS sous_domaine_6, t0.coordonnateur_id AS coordonnateur_id_7 FROM programme t0 WHERE t0.sous_domaine = 'transfagri.angara-finance.net' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nature AS nature_3,
  t0.type AS type_4,
  t0.description AS description_5,
  t0.condition_gouvernance AS condition_gouvernance_6,
  t0.condition_garantie AS condition_garantie_7,
  t0.condition_service_or_produit AS condition_service_or_produit_8,
  t0.caractere_appui_financier AS caractere_appui_financier_9,
  t0.nature_appui_financier_id AS nature_appui_financier_id_10
FROM
  appui t0
WHERE
  t0.nature = ?
  AND t0.type = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nature AS nature_3, t0.type AS type_4, t0.description AS description_5, t0.condition_gouvernance AS condition_gouvernance_6, t0.condition_garantie AS condition_garantie_7, t0.condition_service_or_produit AS condition_service_or_produit_8, t0.caractere_appui_financier AS caractere_appui_financier_9, t0.nature_appui_financier_id AS nature_appui_financier_id_10 FROM appui t0 WHERE t0.nature = 'Appui financier' AND t0.type = 'Appui retenu';

SELECT
  t0.id AS id_1,
  t0.pilote_par_composante AS pilote_par_composante_2,
  t0.quote_part_entreprise AS quote_part_entreprise_3,
  t0.quote_part_composante AS quote_part_composante_4,
  t0.cout_estimatif_appui AS cout_estimatif_appui_5,
  t0.appui_id AS appui_id_6,
  t0.programme_id AS programme_id_7,
  t0.composante_operationnelle_id AS composante_operationnelle_id_8
FROM
  programme_appui t0
WHERE
  t0.programme_id = ?
  AND t0.appui_id IN (?)

SELECT t0.id AS id_1, t0.pilote_par_composante AS pilote_par_composante_2, t0.quote_part_entreprise AS quote_part_entreprise_3, t0.quote_part_composante AS quote_part_composante_4, t0.cout_estimatif_appui AS cout_estimatif_appui_5, t0.appui_id AS appui_id_6, t0.programme_id AS programme_id_7, t0.composante_operationnelle_id AS composante_operationnelle_id_8 FROM programme_appui t0 WHERE t0.programme_id = 1 AND t0.appui_id IN (65, 66, 67, 68, 69, 70, 71, 72, 73, 74);

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.duree AS duree_3,
  t0.description AS description_4,
  t0.montant AS montant_5,
  t0.sous_domaine AS sous_domaine_6,
  t0.coordonnateur_id AS coordonnateur_id_7
FROM
  programme t0
WHERE
  t0.sous_domaine = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.duree AS duree_3, t0.description AS description_4, t0.montant AS montant_5, t0.sous_domaine AS sous_domaine_6, t0.coordonnateur_id AS coordonnateur_id_7 FROM programme t0 WHERE t0.sous_domaine = 'transfagri.angara-finance.net' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.duree AS duree_2,
  p0_.description AS description_3,
  p0_.montant AS montant_4,
  p0_.sous_domaine AS sous_domaine_5,
  p0_.coordonnateur_id AS coordonnateur_id_6
FROM
  programme p0_
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.duree AS duree_2, p0_.description AS description_3, p0_.montant AS montant_4, p0_.sous_domaine AS sous_domaine_5, p0_.coordonnateur_id AS coordonnateur_id_6 FROM programme p0_ ORDER BY p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nature AS nature_3,
  t0.type AS type_4,
  t0.description AS description_5,
  t0.condition_gouvernance AS condition_gouvernance_6,
  t0.condition_garantie AS condition_garantie_7,
  t0.condition_service_or_produit AS condition_service_or_produit_8,
  t0.caractere_appui_financier AS caractere_appui_financier_9,
  t0.nature_appui_financier_id AS nature_appui_financier_id_10
FROM
  appui t0
WHERE
  t0.nature = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nature AS nature_3, t0.type AS type_4, t0.description AS description_5, t0.condition_gouvernance AS condition_gouvernance_6, t0.condition_garantie AS condition_garantie_7, t0.condition_service_or_produit AS condition_service_or_produit_8, t0.caractere_appui_financier AS caractere_appui_financier_9, t0.nature_appui_financier_id AS nature_appui_financier_id_10 FROM appui t0 WHERE t0.nature = 'Appui non financier';

SELECT
  t0.id AS id_1,
  t0.pilote_par_composante AS pilote_par_composante_2,
  t0.quote_part_entreprise AS quote_part_entreprise_3,
  t0.quote_part_composante AS quote_part_composante_4,
  t0.cout_estimatif_appui AS cout_estimatif_appui_5,
  t0.appui_id AS appui_id_6,
  t0.programme_id AS programme_id_7,
  t0.composante_operationnelle_id AS composante_operationnelle_id_8
FROM
  programme_appui t0
WHERE
  t0.programme_id IN (?)
  AND t0.appui_id IN (?)

SELECT t0.id AS id_1, t0.pilote_par_composante AS pilote_par_composante_2, t0.quote_part_entreprise AS quote_part_entreprise_3, t0.quote_part_composante AS quote_part_composante_4, t0.cout_estimatif_appui AS cout_estimatif_appui_5, t0.appui_id AS appui_id_6, t0.programme_id AS programme_id_7, t0.composante_operationnelle_id AS composante_operationnelle_id_8 FROM programme_appui t0 WHERE t0.programme_id IN (1, 2) AND t0.appui_id IN (1, 2, 3, 4, 5, 7, 8, 9, 11, 12, 13, 14, 16, 17, 18, 19, 20, 22, 23, 24, 28, 29, 30, 31, 32, 33, 34, 35, 36, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50);

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.duree AS duree_3,
  t0.description AS description_4,
  t0.montant AS montant_5,
  t0.sous_domaine AS sous_domaine_6,
  t0.coordonnateur_id AS coordonnateur_id_7
FROM
  programme t0
WHERE
  t0.sous_domaine = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.duree AS duree_3, t0.description AS description_4, t0.montant AS montant_5, t0.sous_domaine AS sous_domaine_6, t0.coordonnateur_id AS coordonnateur_id_7 FROM programme t0 WHERE t0.sous_domaine = 'transfagri.angara-finance.net' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.duree AS duree_2,
  p0_.description AS description_3,
  p0_.montant AS montant_4,
  p0_.sous_domaine AS sous_domaine_5,
  p0_.coordonnateur_id AS coordonnateur_id_6
FROM
  programme p0_
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.duree AS duree_2, p0_.description AS description_3, p0_.montant AS montant_4, p0_.sous_domaine AS sous_domaine_5, p0_.coordonnateur_id AS coordonnateur_id_6 FROM programme p0_ ORDER BY p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nature AS nature_3,
  t0.type AS type_4,
  t0.description AS description_5,
  t0.condition_gouvernance AS condition_gouvernance_6,
  t0.condition_garantie AS condition_garantie_7,
  t0.condition_service_or_produit AS condition_service_or_produit_8,
  t0.caractere_appui_financier AS caractere_appui_financier_9,
  t0.nature_appui_financier_id AS nature_appui_financier_id_10
FROM
  appui t0
WHERE
  t0.nature = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nature AS nature_3, t0.type AS type_4, t0.description AS description_5, t0.condition_gouvernance AS condition_gouvernance_6, t0.condition_garantie AS condition_garantie_7, t0.condition_service_or_produit AS condition_service_or_produit_8, t0.caractere_appui_financier AS caractere_appui_financier_9, t0.nature_appui_financier_id AS nature_appui_financier_id_10 FROM appui t0 WHERE t0.nature = 'Appui non financier';

SELECT
  t0.id AS id_1,
  t0.pilote_par_composante AS pilote_par_composante_2,
  t0.quote_part_entreprise AS quote_part_entreprise_3,
  t0.quote_part_composante AS quote_part_composante_4,
  t0.cout_estimatif_appui AS cout_estimatif_appui_5,
  t0.appui_id AS appui_id_6,
  t0.programme_id AS programme_id_7,
  t0.composante_operationnelle_id AS composante_operationnelle_id_8
FROM
  programme_appui t0
WHERE
  t0.programme_id IN (?)
  AND t0.appui_id IN (?)

SELECT t0.id AS id_1, t0.pilote_par_composante AS pilote_par_composante_2, t0.quote_part_entreprise AS quote_part_entreprise_3, t0.quote_part_composante AS quote_part_composante_4, t0.cout_estimatif_appui AS cout_estimatif_appui_5, t0.appui_id AS appui_id_6, t0.programme_id AS programme_id_7, t0.composante_operationnelle_id AS composante_operationnelle_id_8 FROM programme_appui t0 WHERE t0.programme_id IN (1, 2) AND t0.appui_id IN (1, 2, 3, 4, 5, 7, 8, 9, 11, 12, 13, 14, 16, 17, 18, 19, 20, 22, 23, 24, 28, 29, 30, 31, 32, 33, 34, 35, 36, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50);

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.duree AS duree_3,
  t0.description AS description_4,
  t0.montant AS montant_5,
  t0.sous_domaine AS sous_domaine_6,
  t0.coordonnateur_id AS coordonnateur_id_7
FROM
  programme t0
WHERE
  t0.sous_domaine = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.duree AS duree_3, t0.description AS description_4, t0.montant AS montant_5, t0.sous_domaine AS sous_domaine_6, t0.coordonnateur_id AS coordonnateur_id_7 FROM programme t0 WHERE t0.sous_domaine = 'transfagri.angara-finance.net' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.duree AS duree_2,
  p0_.description AS description_3,
  p0_.montant AS montant_4,
  p0_.sous_domaine AS sous_domaine_5,
  p0_.coordonnateur_id AS coordonnateur_id_6
FROM
  programme p0_
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.duree AS duree_2, p0_.description AS description_3, p0_.montant AS montant_4, p0_.sous_domaine AS sous_domaine_5, p0_.coordonnateur_id AS coordonnateur_id_6 FROM programme p0_ ORDER BY p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nature AS nature_3,
  t0.type AS type_4,
  t0.description AS description_5,
  t0.condition_gouvernance AS condition_gouvernance_6,
  t0.condition_garantie AS condition_garantie_7,
  t0.condition_service_or_produit AS condition_service_or_produit_8,
  t0.caractere_appui_financier AS caractere_appui_financier_9,
  t0.nature_appui_financier_id AS nature_appui_financier_id_10
FROM
  appui t0
WHERE
  t0.nature = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nature AS nature_3, t0.type AS type_4, t0.description AS description_5, t0.condition_gouvernance AS condition_gouvernance_6, t0.condition_garantie AS condition_garantie_7, t0.condition_service_or_produit AS condition_service_or_produit_8, t0.caractere_appui_financier AS caractere_appui_financier_9, t0.nature_appui_financier_id AS nature_appui_financier_id_10 FROM appui t0 WHERE t0.nature = 'Appui non financier';

SELECT
  t0.id AS id_1,
  t0.pilote_par_composante AS pilote_par_composante_2,
  t0.quote_part_entreprise AS quote_part_entreprise_3,
  t0.quote_part_composante AS quote_part_composante_4,
  t0.cout_estimatif_appui AS cout_estimatif_appui_5,
  t0.appui_id AS appui_id_6,
  t0.programme_id AS programme_id_7,
  t0.composante_operationnelle_id AS composante_operationnelle_id_8
FROM
  programme_appui t0
WHERE
  t0.programme_id IN (?)
  AND t0.appui_id IN (?)

SELECT t0.id AS id_1, t0.pilote_par_composante AS pilote_par_composante_2, t0.quote_part_entreprise AS quote_part_entreprise_3, t0.quote_part_composante AS quote_part_composante_4, t0.cout_estimatif_appui AS cout_estimatif_appui_5, t0.appui_id AS appui_id_6, t0.programme_id AS programme_id_7, t0.composante_operationnelle_id AS composante_operationnelle_id_8 FROM programme_appui t0 WHERE t0.programme_id IN (1, 2) AND t0.appui_id IN (1, 2, 3, 4, 5, 7, 8, 9, 11, 12, 13, 14, 16, 17, 18, 19, 20, 22, 23, 24, 28, 29, 30, 31, 32, 33, 34, 35, 36, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50);

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  region t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM region t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.region_id AS region_id_3
FROM
  departement t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.region_id AS region_id_3 FROM departement t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.departement_id AS departement_id_3
FROM
  commune t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.departement_id AS departement_id_3 FROM commune t0;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.code AS code_2,
  s0_.branch_id AS branch_id_3
FROM
  sector s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.branch_id AS branch_id_3 FROM sector s0_;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.code AS code_2,
  s1_.id AS id_3,
  s1_.name AS name_4,
  s1_.code AS code_5,
  s0_.sector_id AS sector_id_6,
  s1_.branch_id AS branch_id_7
FROM
  service s0_
  INNER JOIN sector s1_ ON s0_.sector_id = s1_.id
WHERE
  s1_.id = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s1_.id AS id_3, s1_.name AS name_4, s1_.code AS code_5, s0_.sector_id AS sector_id_6, s1_.branch_id AS branch_id_7 FROM service s0_ INNER JOIN sector s1_ ON s0_.sector_id = s1_.id WHERE s1_.id = NULL;

SELECT
  s0_.id AS id_0,
  s0_.secteur_activite AS secteur_activite_1,
  s0_.programme_id AS programme_id_2
FROM
  secteur_activite_programme s0_

SELECT s0_.id AS id_0, s0_.secteur_activite AS secteur_activite_1, s0_.programme_id AS programme_id_2 FROM secteur_activite_programme s0_;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.city AS city_3,
  s0_.email AS email_4,
  s0_.telephone AS telephone_5,
  s0_.country AS country_6,
  s0_.region AS region_7,
  c1_.id AS id_8,
  c1_.name AS name_9,
  c1_.status AS status_10,
  c1_.slug AS slug_11,
  c1_.rang AS rang_12,
  c1_.multiple AS multiple_13,
  c1_.enterprise AS enterprise_14,
  c1_.view_all AS view_all_15,
  c1_.incubation AS incubation_16,
  s0_.category_id AS category_id_17,
  s0_.parent_structure_id AS parent_structure_id_18,
  c1_.depends_on_id AS depends_on_id_19
FROM
  structure s0_
  INNER JOIN category_structure c1_ ON s0_.category_id = c1_.id
WHERE
  c1_.incubation = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.city AS city_3, s0_.email AS email_4, s0_.telephone AS telephone_5, s0_.country AS country_6, s0_.region AS region_7, c1_.id AS id_8, c1_.name AS name_9, c1_.status AS status_10, c1_.slug AS slug_11, c1_.rang AS rang_12, c1_.multiple AS multiple_13, c1_.enterprise AS enterprise_14, c1_.view_all AS view_all_15, c1_.incubation AS incubation_16, s0_.category_id AS category_id_17, s0_.parent_structure_id AS parent_structure_id_18, c1_.depends_on_id AS depends_on_id_19 FROM structure s0_ INNER JOIN category_structure c1_ ON s0_.category_id = c1_.id WHERE c1_.incubation = 1;