Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.symbole_chimique AS symbole_chimique_2,
  t0.nom AS nom_3,
  t0.reserve_approv AS reserve_approv_4,
  t0.code AS code_5,
  t0.unite AS unite_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.filiere_id AS filiere_id_10,
  t0.localisation_id AS localisation_id_11,
  t0.user_id AS user_id_12
FROM
  commodite t0

SELECT t0.id AS id_1, t0.symbole_chimique AS symbole_chimique_2, t0.nom AS nom_3, t0.reserve_approv AS reserve_approv_4, t0.code AS code_5, t0.unite AS unite_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.filiere_id AS filiere_id_10, t0.localisation_id AS localisation_id_11, t0.user_id AS user_id_12 FROM commodite t0;

SELECT
  o0_.id AS id_0,
  o0_.denomination AS denomination_1,
  o0_.sigle AS sigle_2,
  o0_.statut AS statut_3,
  o0_.nature AS nature_4,
  o0_.raison_sociale AS raison_sociale_5,
  o0_.regime_fiscal AS regime_fiscal_6,
  o0_.siege AS siege_7,
  o0_.annee_fermeture AS annee_fermeture_8,
  o0_.nombre_surccursale AS nombre_surccursale_9,
  o0_.code_unique AS code_unique_10,
  o0_.rccm AS rccm_11,
  o0_.id_nationnal AS id_nationnal_12,
  o0_.num_ident_fiscal AS num_ident_fiscal_13,
  o0_.num_import_export AS num_import_export_14,
  o0_.num_affactation_inss AS num_affactation_inss_15,
  o0_.num_affectation_inpp AS num_affectation_inpp_16,
  o0_.num_compte_bancaire_interne AS num_compte_bancaire_interne_17,
  o0_.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_18,
  o0_.capital_social AS capital_social_19,
  o0_.num_tva AS num_tva_20,
  o0_.num_dgda AS num_dgda_21,
  o0_.num_dgi AS num_dgi_22,
  o0_.num_dgrad AS num_dgrad_23,
  o0_.num_occ AS num_occ_24,
  o0_.boite_postal AS boite_postal_25,
  o0_.fax AS fax_26,
  o0_.telephone AS telephone_27,
  o0_.site_web AS site_web_28,
  o0_.email AS email_29,
  o0_.fichier AS fichier_30,
  o0_.nom_original AS nom_original_31,
  o0_.description AS description_32,
  o0_.anne_creation AS anne_creation_33,
  o0_.code_operateur AS code_operateur_34,
  o0_.code_indentification AS code_indentification_35,
  o0_.date_creation AS date_creation_36,
  o0_.service AS service_37,
  o0_.profil_oil AS profil_oil_38,
  o0_.detail_regime AS detail_regime_39,
  o0_.zone AS zone_40,
  o0_.date_agrement AS date_agrement_41,
  o0_.date_expiration_agrement AS date_expiration_agrement_42,
  o0_.created_at AS created_at_43,
  o0_.updated_at AS updated_at_44,
  o0_.deleted_at AS deleted_at_45,
  o0_.categorie_id AS categorie_id_46,
  o0_.forme_juridique_id AS forme_juridique_id_47,
  o0_.ville_id AS ville_id_48,
  o0_.sous_secteur_id AS sous_secteur_id_49,
  o0_.etd_id AS etd_id_50,
  o0_.province_id AS province_id_51,
  o0_.secteur_id AS secteur_id_52,
  o0_.user_id AS user_id_53
FROM
  operateur o0_
  INNER JOIN vente_local v1_ ON o0_.id = v1_.acheteur_id

SELECT o0_.id AS id_0, o0_.denomination AS denomination_1, o0_.sigle AS sigle_2, o0_.statut AS statut_3, o0_.nature AS nature_4, o0_.raison_sociale AS raison_sociale_5, o0_.regime_fiscal AS regime_fiscal_6, o0_.siege AS siege_7, o0_.annee_fermeture AS annee_fermeture_8, o0_.nombre_surccursale AS nombre_surccursale_9, o0_.code_unique AS code_unique_10, o0_.rccm AS rccm_11, o0_.id_nationnal AS id_nationnal_12, o0_.num_ident_fiscal AS num_ident_fiscal_13, o0_.num_import_export AS num_import_export_14, o0_.num_affactation_inss AS num_affactation_inss_15, o0_.num_affectation_inpp AS num_affectation_inpp_16, o0_.num_compte_bancaire_interne AS num_compte_bancaire_interne_17, o0_.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_18, o0_.capital_social AS capital_social_19, o0_.num_tva AS num_tva_20, o0_.num_dgda AS num_dgda_21, o0_.num_dgi AS num_dgi_22, o0_.num_dgrad AS num_dgrad_23, o0_.num_occ AS num_occ_24, o0_.boite_postal AS boite_postal_25, o0_.fax AS fax_26, o0_.telephone AS telephone_27, o0_.site_web AS site_web_28, o0_.email AS email_29, o0_.fichier AS fichier_30, o0_.nom_original AS nom_original_31, o0_.description AS description_32, o0_.anne_creation AS anne_creation_33, o0_.code_operateur AS code_operateur_34, o0_.code_indentification AS code_indentification_35, o0_.date_creation AS date_creation_36, o0_.service AS service_37, o0_.profil_oil AS profil_oil_38, o0_.detail_regime AS detail_regime_39, o0_.zone AS zone_40, o0_.date_agrement AS date_agrement_41, o0_.date_expiration_agrement AS date_expiration_agrement_42, o0_.created_at AS created_at_43, o0_.updated_at AS updated_at_44, o0_.deleted_at AS deleted_at_45, o0_.categorie_id AS categorie_id_46, o0_.forme_juridique_id AS forme_juridique_id_47, o0_.ville_id AS ville_id_48, o0_.sous_secteur_id AS sous_secteur_id_49, o0_.etd_id AS etd_id_50, o0_.province_id AS province_id_51, o0_.secteur_id AS secteur_id_52, o0_.user_id AS user_id_53 FROM operateur o0_ INNER JOIN vente_local v1_ ON o0_.id = v1_.acheteur_id;

SELECT
  SUM(v0_.quantite) AS sclr_0,
  SUBSTRING(
    v0_.date_vente
    FROM
      6 FOR 2
  ) AS sclr_1
FROM
  vente_local v0_
WHERE
  (
    v0_.date_vente BETWEEN ?
    AND ?
  )
  AND v0_.commodite_id = ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT SUM(v0_.quantite) AS sclr_0, SUBSTRING(v0_.date_vente FROM 6 FOR 2) AS sclr_1 FROM vente_local v0_ WHERE (v0_.date_vente BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:00') AND v0_.commodite_id = 1 GROUP BY sclr_1 ORDER BY sclr_1 ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.unite AS unite_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.user_id AS user_id_8
FROM
  filiere t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.unite AS unite_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM filiere t0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.user_id AS user_id_7
FROM
  categorie t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM categorie t0;

SELECT
  t0.id AS id_1,
  t0.nom_gisement AS nom_gisement_2,
  t0.nom_mine AS nom_mine_3,
  t0.ressource AS ressource_4,
  t0.teneur AS teneur_5,
  t0.metal_contenu AS metal_contenu_6,
  t0.longitude AS longitude_7,
  t0.latitude AS latitude_8,
  t0.annotation AS annotation_9,
  t0.date_debut AS date_debut_10,
  t0.code AS code_11,
  t0.details AS details_12,
  t0.superficie_on AS superficie_on_13,
  t0.superficie_off AS superficie_off_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.deleted_at AS deleted_at_17,
  t0.operateur_id AS operateur_id_18,
  t0.province_id AS province_id_19,
  t0.user_id AS user_id_20
FROM
  gisement t0

SELECT t0.id AS id_1, t0.nom_gisement AS nom_gisement_2, t0.nom_mine AS nom_mine_3, t0.ressource AS ressource_4, t0.teneur AS teneur_5, t0.metal_contenu AS metal_contenu_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.annotation AS annotation_9, t0.date_debut AS date_debut_10, t0.code AS code_11, t0.details AS details_12, t0.superficie_on AS superficie_on_13, t0.superficie_off AS superficie_off_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17, t0.operateur_id AS operateur_id_18, t0.province_id AS province_id_19, t0.user_id AS user_id_20 FROM gisement t0;

SELECT
  SUM(v0_.quantite) AS sclr_0,
  SUBSTRING(
    v0_.date_vente
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  vente_local v0_
WHERE
  v0_.commodite_id = ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT SUM(v0_.quantite) AS sclr_0, SUBSTRING(v0_.date_vente FROM 1 FOR 4) AS sclr_1 FROM vente_local v0_ WHERE v0_.commodite_id = 1 GROUP BY sclr_1 ORDER BY sclr_1 ASC;