Symfony Profiler

SELECT
  g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0,
  g0_.code AS code_1,
  g0_.libelle AS libelle_2,
  g0_.fa_icon AS fa_icon_3,
  g0_.color AS color_4,
  g0_.is_active AS is_active_5,
  g0_.structure AS structure_6
FROM
  gpso_flux_ou_prestation g0_
WHERE
  g0_.structure = ?
  AND g0_.code = ?

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.code AS code_1, g0_.libelle AS libelle_2, g0_.fa_icon AS fa_icon_3, g0_.color AS color_4, g0_.is_active AS is_active_5, g0_.structure AS structure_6 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = 102 AND g0_.code = 'OMR';

SELECT
  t0.id_decheterie AS id_decheterie_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.telephone AS telephone_6,
  t0.open_lun_matin AS open_lun_matin_7,
  t0.open_lun_aprem AS open_lun_aprem_8,
  t0.open_mar_matin AS open_mar_matin_9,
  t0.open_mar_aprem AS open_mar_aprem_10,
  t0.open_mer_matin AS open_mer_matin_11,
  t0.open_mer_aprem AS open_mer_aprem_12,
  t0.open_jeu_matin AS open_jeu_matin_13,
  t0.open_jeu_aprem AS open_jeu_aprem_14,
  t0.open_ven_matin AS open_ven_matin_15,
  t0.open_ven_aprem AS open_ven_aprem_16,
  t0.open_sam_matin AS open_sam_matin_17,
  t0.open_sam_aprem AS open_sam_aprem_18,
  t0.open_dim_matin AS open_dim_matin_19,
  t0.open_dim_aprem AS open_dim_aprem_20,
  t0.icon AS icon_21,
  t0.conditions_acces AS conditions_acces_22,
  t0.informations AS informations_23,
  t0.photo_1 AS photo_1_24,
  t0.photo_2 AS photo_2_25,
  t0.photo_3 AS photo_3_26,
  t0.visible AS visible_27,
  t0.id_tc_flux AS id_tc_flux_28,
  t0.id_tc_ville AS id_tc_ville_29
FROM
  decheterie t0
WHERE
  t0.id_tc_flux = ?

SELECT t0.id_decheterie AS id_decheterie_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.telephone AS telephone_6, t0.open_lun_matin AS open_lun_matin_7, t0.open_lun_aprem AS open_lun_aprem_8, t0.open_mar_matin AS open_mar_matin_9, t0.open_mar_aprem AS open_mar_aprem_10, t0.open_mer_matin AS open_mer_matin_11, t0.open_mer_aprem AS open_mer_aprem_12, t0.open_jeu_matin AS open_jeu_matin_13, t0.open_jeu_aprem AS open_jeu_aprem_14, t0.open_ven_matin AS open_ven_matin_15, t0.open_ven_aprem AS open_ven_aprem_16, t0.open_sam_matin AS open_sam_matin_17, t0.open_sam_aprem AS open_sam_aprem_18, t0.open_dim_matin AS open_dim_matin_19, t0.open_dim_aprem AS open_dim_aprem_20, t0.icon AS icon_21, t0.conditions_acces AS conditions_acces_22, t0.informations AS informations_23, t0.photo_1 AS photo_1_24, t0.photo_2 AS photo_2_25, t0.photo_3 AS photo_3_26, t0.visible AS visible_27, t0.id_tc_flux AS id_tc_flux_28, t0.id_tc_ville AS id_tc_ville_29 FROM decheterie t0 WHERE t0.id_tc_flux = 443;

SELECT
  t0.id_tonnage AS id_tonnage_1,
  t0.annee AS annee_2,
  t0.tonnes AS tonnes_3,
  t0.habitants AS habitants_4,
  t0.id_tc_flux AS id_tc_flux_5,
  t0.id_tc_structure AS id_tc_structure_6
FROM
  tonnage t0
WHERE
  t0.id_tc_flux = ?

SELECT t0.id_tonnage AS id_tonnage_1, t0.annee AS annee_2, t0.tonnes AS tonnes_3, t0.habitants AS habitants_4, t0.id_tc_flux AS id_tc_flux_5, t0.id_tc_structure AS id_tc_structure_6 FROM tonnage t0 WHERE t0.id_tc_flux = 443;

SELECT
  t0.id_objectif AS id_objectif_1,
  t0.id_tonnage AS id_tonnage_2,
  t0.annee AS annee_3,
  t0.tonnes AS tonnes_4,
  t0.habitants AS habitants_5,
  t0.id_tc_flux AS id_tc_flux_6,
  t0.id_tc_structure AS id_tc_structure_7
FROM
  objectif t0
WHERE
  t0.id_tc_flux = ?

SELECT t0.id_objectif AS id_objectif_1, t0.id_tonnage AS id_tonnage_2, t0.annee AS annee_3, t0.tonnes AS tonnes_4, t0.habitants AS habitants_5, t0.id_tc_flux AS id_tc_flux_6, t0.id_tc_structure AS id_tc_structure_7 FROM objectif t0 WHERE t0.id_tc_flux = 443;

SELECT
  g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0,
  g0_.code AS code_1,
  g0_.libelle AS libelle_2,
  g0_.fa_icon AS fa_icon_3,
  g0_.color AS color_4,
  g0_.is_active AS is_active_5,
  g0_.structure AS structure_6
FROM
  gpso_flux_ou_prestation g0_
WHERE
  g0_.structure = ?
  AND g0_.code = ?

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.code AS code_1, g0_.libelle AS libelle_2, g0_.fa_icon AS fa_icon_3, g0_.color AS color_4, g0_.is_active AS is_active_5, g0_.structure AS structure_6 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = 102 AND g0_.code = 'OMR';

SELECT
  t0.id_cout AS id_cout_1,
  t0.annee AS annee_2,
  t0.depense AS depense_3,
  t0.id_tc_structure AS id_tc_structure_4,
  t0.id_tc_flux AS id_tc_flux_5
FROM
  cout t0
WHERE
  t0.id_tc_flux = ?

SELECT t0.id_cout AS id_cout_1, t0.annee AS annee_2, t0.depense AS depense_3, t0.id_tc_structure AS id_tc_structure_4, t0.id_tc_flux AS id_tc_flux_5 FROM cout t0 WHERE t0.id_tc_flux = 443;

SELECT
  g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0,
  g0_.code AS code_1,
  g0_.libelle AS libelle_2,
  g0_.fa_icon AS fa_icon_3,
  g0_.color AS color_4,
  g0_.is_active AS is_active_5,
  g0_.structure AS structure_6
FROM
  gpso_flux_ou_prestation g0_
WHERE
  g0_.structure = ?
  AND g0_.code = ?

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.code AS code_1, g0_.libelle AS libelle_2, g0_.fa_icon AS fa_icon_3, g0_.color AS color_4, g0_.is_active AS is_active_5, g0_.structure AS structure_6 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = 102 AND g0_.code = 'CS';

SELECT
  t0.id_decheterie AS id_decheterie_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.telephone AS telephone_6,
  t0.open_lun_matin AS open_lun_matin_7,
  t0.open_lun_aprem AS open_lun_aprem_8,
  t0.open_mar_matin AS open_mar_matin_9,
  t0.open_mar_aprem AS open_mar_aprem_10,
  t0.open_mer_matin AS open_mer_matin_11,
  t0.open_mer_aprem AS open_mer_aprem_12,
  t0.open_jeu_matin AS open_jeu_matin_13,
  t0.open_jeu_aprem AS open_jeu_aprem_14,
  t0.open_ven_matin AS open_ven_matin_15,
  t0.open_ven_aprem AS open_ven_aprem_16,
  t0.open_sam_matin AS open_sam_matin_17,
  t0.open_sam_aprem AS open_sam_aprem_18,
  t0.open_dim_matin AS open_dim_matin_19,
  t0.open_dim_aprem AS open_dim_aprem_20,
  t0.icon AS icon_21,
  t0.conditions_acces AS conditions_acces_22,
  t0.informations AS informations_23,
  t0.photo_1 AS photo_1_24,
  t0.photo_2 AS photo_2_25,
  t0.photo_3 AS photo_3_26,
  t0.visible AS visible_27,
  t0.id_tc_flux AS id_tc_flux_28,
  t0.id_tc_ville AS id_tc_ville_29
FROM
  decheterie t0
WHERE
  t0.id_tc_flux = ?

SELECT t0.id_decheterie AS id_decheterie_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.telephone AS telephone_6, t0.open_lun_matin AS open_lun_matin_7, t0.open_lun_aprem AS open_lun_aprem_8, t0.open_mar_matin AS open_mar_matin_9, t0.open_mar_aprem AS open_mar_aprem_10, t0.open_mer_matin AS open_mer_matin_11, t0.open_mer_aprem AS open_mer_aprem_12, t0.open_jeu_matin AS open_jeu_matin_13, t0.open_jeu_aprem AS open_jeu_aprem_14, t0.open_ven_matin AS open_ven_matin_15, t0.open_ven_aprem AS open_ven_aprem_16, t0.open_sam_matin AS open_sam_matin_17, t0.open_sam_aprem AS open_sam_aprem_18, t0.open_dim_matin AS open_dim_matin_19, t0.open_dim_aprem AS open_dim_aprem_20, t0.icon AS icon_21, t0.conditions_acces AS conditions_acces_22, t0.informations AS informations_23, t0.photo_1 AS photo_1_24, t0.photo_2 AS photo_2_25, t0.photo_3 AS photo_3_26, t0.visible AS visible_27, t0.id_tc_flux AS id_tc_flux_28, t0.id_tc_ville AS id_tc_ville_29 FROM decheterie t0 WHERE t0.id_tc_flux = 444;

SELECT
  t0.id_tonnage AS id_tonnage_1,
  t0.annee AS annee_2,
  t0.tonnes AS tonnes_3,
  t0.habitants AS habitants_4,
  t0.id_tc_flux AS id_tc_flux_5,
  t0.id_tc_structure AS id_tc_structure_6
FROM
  tonnage t0
WHERE
  t0.id_tc_flux = ?

SELECT t0.id_tonnage AS id_tonnage_1, t0.annee AS annee_2, t0.tonnes AS tonnes_3, t0.habitants AS habitants_4, t0.id_tc_flux AS id_tc_flux_5, t0.id_tc_structure AS id_tc_structure_6 FROM tonnage t0 WHERE t0.id_tc_flux = 444;

SELECT
  t0.id_objectif AS id_objectif_1,
  t0.id_tonnage AS id_tonnage_2,
  t0.annee AS annee_3,
  t0.tonnes AS tonnes_4,
  t0.habitants AS habitants_5,
  t0.id_tc_flux AS id_tc_flux_6,
  t0.id_tc_structure AS id_tc_structure_7
FROM
  objectif t0
WHERE
  t0.id_tc_flux = ?

SELECT t0.id_objectif AS id_objectif_1, t0.id_tonnage AS id_tonnage_2, t0.annee AS annee_3, t0.tonnes AS tonnes_4, t0.habitants AS habitants_5, t0.id_tc_flux AS id_tc_flux_6, t0.id_tc_structure AS id_tc_structure_7 FROM objectif t0 WHERE t0.id_tc_flux = 444;

SELECT
  g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0,
  g0_.code AS code_1,
  g0_.libelle AS libelle_2,
  g0_.fa_icon AS fa_icon_3,
  g0_.color AS color_4,
  g0_.is_active AS is_active_5,
  g0_.structure AS structure_6
FROM
  gpso_flux_ou_prestation g0_
WHERE
  g0_.structure = ?
  AND g0_.code = ?

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.code AS code_1, g0_.libelle AS libelle_2, g0_.fa_icon AS fa_icon_3, g0_.color AS color_4, g0_.is_active AS is_active_5, g0_.structure AS structure_6 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = 102 AND g0_.code = 'CS';

SELECT
  t0.id_cout AS id_cout_1,
  t0.annee AS annee_2,
  t0.depense AS depense_3,
  t0.id_tc_structure AS id_tc_structure_4,
  t0.id_tc_flux AS id_tc_flux_5
FROM
  cout t0
WHERE
  t0.id_tc_flux = ?

SELECT t0.id_cout AS id_cout_1, t0.annee AS annee_2, t0.depense AS depense_3, t0.id_tc_structure AS id_tc_structure_4, t0.id_tc_flux AS id_tc_flux_5 FROM cout t0 WHERE t0.id_tc_flux = 444;

SELECT
  g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0,
  g0_.code AS code_1,
  g0_.libelle AS libelle_2,
  g0_.fa_icon AS fa_icon_3,
  g0_.color AS color_4,
  g0_.is_active AS is_active_5,
  g0_.structure AS structure_6
FROM
  gpso_flux_ou_prestation g0_
WHERE
  g0_.structure = ?
  AND g0_.code = ?

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.code AS code_1, g0_.libelle AS libelle_2, g0_.fa_icon AS fa_icon_3, g0_.color AS color_4, g0_.is_active AS is_active_5, g0_.structure AS structure_6 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = 102 AND g0_.code = 'OMR';

SELECT
  g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0,
  g0_.code AS code_1,
  g0_.libelle AS libelle_2,
  g0_.fa_icon AS fa_icon_3,
  g0_.color AS color_4,
  g0_.is_active AS is_active_5,
  g0_.structure AS structure_6
FROM
  gpso_flux_ou_prestation g0_
WHERE
  g0_.structure = ?
  AND g0_.code = ?

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.code AS code_1, g0_.libelle AS libelle_2, g0_.fa_icon AS fa_icon_3, g0_.color AS color_4, g0_.is_active AS is_active_5, g0_.structure AS structure_6 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = 102 AND g0_.code = 'CS';

SELECT
  g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0,
  g0_.code AS code_1,
  g0_.libelle AS libelle_2,
  g0_.fa_icon AS fa_icon_3,
  g0_.color AS color_4,
  g0_.is_active AS is_active_5,
  g0_.structure AS structure_6
FROM
  gpso_flux_ou_prestation g0_
WHERE
  g0_.structure = ?
  AND g0_.code = ?

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.code AS code_1, g0_.libelle AS libelle_2, g0_.fa_icon AS fa_icon_3, g0_.color AS color_4, g0_.is_active AS is_active_5, g0_.structure AS structure_6 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = 102 AND g0_.code = 'OMR';

SELECT
  g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0,
  g0_.code AS code_1,
  g0_.libelle AS libelle_2,
  g0_.fa_icon AS fa_icon_3,
  g0_.color AS color_4,
  g0_.is_active AS is_active_5,
  g0_.structure AS structure_6
FROM
  gpso_flux_ou_prestation g0_
WHERE
  g0_.structure = ?
  AND g0_.code = ?

SELECT g0_.id_gpso_flux_ou_prestation AS id_gpso_flux_ou_prestation_0, g0_.code AS code_1, g0_.libelle AS libelle_2, g0_.fa_icon AS fa_icon_3, g0_.color AS color_4, g0_.is_active AS is_active_5, g0_.structure AS structure_6 FROM gpso_flux_ou_prestation g0_ WHERE g0_.structure = 102 AND g0_.code = 'CS';

SELECT
  v0_.id_valorisation AS id_valorisation_0,
  v0_.annee AS annee_1,
  v0_.tonnes AS tonnes_2,
  v0_.filiere AS filiere_3,
  v0_.is_valorisation AS is_valorisation_4,
  v0_.id_tc_structure AS id_tc_structure_5
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
  AND v0_.annee = ?

SELECT v0_.id_valorisation AS id_valorisation_0, v0_.annee AS annee_1, v0_.tonnes AS tonnes_2, v0_.filiere AS filiere_3, v0_.is_valorisation AS is_valorisation_4, v0_.id_tc_structure AS id_tc_structure_5 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 AND v0_.annee = 2025;

SELECT
  v0_.annee AS annee_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
GROUP BY
  v0_.annee
ORDER BY
  v0_.annee ASC

SELECT v0_.annee AS annee_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 GROUP BY v0_.annee ORDER BY v0_.annee ASC;

SELECT
  v0_.annee AS annee_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
GROUP BY
  v0_.annee
ORDER BY
  v0_.annee ASC

SELECT v0_.annee AS annee_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 GROUP BY v0_.annee ORDER BY v0_.annee ASC;

SELECT
  SUM(v0_.tonnes) AS sclr_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
  AND v0_.annee = ?
  AND v0_.is_valorisation = 1

SELECT SUM(v0_.tonnes) AS sclr_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 AND v0_.annee = 2021 AND v0_.is_valorisation = 1;

SELECT
  SUM(v0_.tonnes) AS sclr_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
  AND v0_.annee = ?

SELECT SUM(v0_.tonnes) AS sclr_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 AND v0_.annee = 2021;

SELECT
  SUM(v0_.tonnes) AS sclr_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
  AND v0_.annee = ?
  AND v0_.is_valorisation = 1

SELECT SUM(v0_.tonnes) AS sclr_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 AND v0_.annee = 2022 AND v0_.is_valorisation = 1;

SELECT
  SUM(v0_.tonnes) AS sclr_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
  AND v0_.annee = ?

SELECT SUM(v0_.tonnes) AS sclr_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 AND v0_.annee = 2022;

SELECT
  SUM(v0_.tonnes) AS sclr_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
  AND v0_.annee = ?
  AND v0_.is_valorisation = 1

SELECT SUM(v0_.tonnes) AS sclr_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 AND v0_.annee = 2023 AND v0_.is_valorisation = 1;

SELECT
  SUM(v0_.tonnes) AS sclr_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
  AND v0_.annee = ?

SELECT SUM(v0_.tonnes) AS sclr_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 AND v0_.annee = 2023;

SELECT
  SUM(v0_.tonnes) AS sclr_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
  AND v0_.annee = ?
  AND v0_.is_valorisation = 1

SELECT SUM(v0_.tonnes) AS sclr_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 AND v0_.annee = 2024 AND v0_.is_valorisation = 1;

SELECT
  SUM(v0_.tonnes) AS sclr_0
FROM
  valorisation v0_
WHERE
  v0_.id_tc_structure = ?
  AND v0_.annee = ?

SELECT SUM(v0_.tonnes) AS sclr_0 FROM valorisation v0_ WHERE v0_.id_tc_structure = 102 AND v0_.annee = 2024;