Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.date_cours AS date_cours_1,
  c0_.prix AS prix_2,
  c0_.bourse AS bourse_3,
  c0_.teneur AS teneur_4,
  c0_.mode AS mode_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.deleted_at AS deleted_at_8,
  c0_.commodite_id AS commodite_id_9,
  c0_.type_commodite_id AS type_commodite_id_10,
  c0_.user_id AS user_id_11
FROM
  cours_moyens_des_metaux c0_
WHERE
  c0_.commodite_id = ?
ORDER BY
  c0_.date_cours DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.date_cours AS date_cours_1, c0_.prix AS prix_2, c0_.bourse AS bourse_3, c0_.teneur AS teneur_4, c0_.mode AS mode_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.commodite_id AS commodite_id_9, c0_.type_commodite_id AS type_commodite_id_10, c0_.user_id AS user_id_11 FROM cours_moyens_des_metaux c0_ WHERE c0_.commodite_id = 1 ORDER BY c0_.date_cours DESC LIMIT 1;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0,
  c1_.id AS id_1,
  c1_.nom AS nom_2
FROM
  operateur o0_
  INNER JOIN categorie c1_ ON o0_.categorie_id = c1_.id
  INNER JOIN secteur s2_ ON o0_.secteur_id = s2_.id
WHERE
  s2_.id = ?
GROUP BY
  c1_.id,
  c1_.nom

SELECT COUNT(DISTINCT o0_.id) AS sclr_0, c1_.id AS id_1, c1_.nom AS nom_2 FROM operateur o0_ INNER JOIN categorie c1_ ON o0_.categorie_id = c1_.id INNER JOIN secteur s2_ ON o0_.secteur_id = s2_.id WHERE s2_.id = 3 GROUP BY c1_.id, c1_.nom;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  operateur o0_
WHERE
  o0_.annee_fermeture > ?

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM operateur o0_ WHERE o0_.annee_fermeture > '2018-01-01';

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.user_id AS user_id_19
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.user_id AS user_id_19 FROM gisement t0;

SELECT
  SUM(e0_.quantite) AS sclr_0,
  c1_.nom AS nom_1,
  f2_.unite AS unite_2,
  SUBSTRING(
    e0_.date_exportation
    FROM
      6 FOR 2
  ) AS sclr_3
FROM
  exportation e0_
  INNER JOIN commodite c1_ ON e0_.commodite_id = c1_.id
  INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id
WHERE
  (
    e0_.date_exportation BETWEEN ?
    AND ?
  )
  AND e0_.commodite_id = ?
GROUP BY
  c1_.nom,
  f2_.unite,
  sclr_3
ORDER BY
  sclr_3 ASC

SELECT SUM(e0_.quantite) AS sclr_0, c1_.nom AS nom_1, f2_.unite AS unite_2, SUBSTRING(e0_.date_exportation FROM 6 FOR 2) AS sclr_3 FROM exportation e0_ INNER JOIN commodite c1_ ON e0_.commodite_id = c1_.id INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id WHERE (e0_.date_exportation BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:00') AND e0_.commodite_id = 1 GROUP BY c1_.nom, f2_.unite, sclr_3 ORDER BY sclr_3 ASC;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  contrat_principal c0_
WHERE
  c0_.created_at BETWEEN ?
  AND ?

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_principal c0_ WHERE c0_.created_at BETWEEN '2025-01-01 00:00:00' AND '2025-12-12 23:59:00';

SELECT
  COUNT(DISTINCT g0_.id) AS sclr_0,
  p1_.nom AS nom_1
FROM
  gisement g0_
  INNER JOIN gisement_province g2_ ON g0_.id = g2_.gisement_id
  INNER JOIN province p1_ ON p1_.id = g2_.province_id
GROUP BY
  p1_.nom
ORDER BY
  sclr_0 ASC

SELECT COUNT(DISTINCT g0_.id) AS sclr_0, p1_.nom AS nom_1 FROM gisement g0_ INNER JOIN gisement_province g2_ ON g0_.id = g2_.gisement_id INNER JOIN province p1_ ON p1_.id = g2_.province_id GROUP BY p1_.nom ORDER BY sclr_0 ASC;

SELECT
  SUM(e0_.quantite) AS sclr_0,
  c1_.nom AS nom_1,
  f2_.unite AS unite_2,
  SUBSTRING(
    e0_.date_exportation
    FROM
      1 FOR 4
  ) AS sclr_3
FROM
  exportation e0_
  INNER JOIN commodite c1_ ON e0_.commodite_id = c1_.id
  INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id
WHERE
  e0_.commodite_id = ?
GROUP BY
  c1_.nom,
  f2_.unite,
  sclr_3
ORDER BY
  sclr_3 ASC

SELECT SUM(e0_.quantite) AS sclr_0, c1_.nom AS nom_1, f2_.unite AS unite_2, SUBSTRING(e0_.date_exportation FROM 1 FOR 4) AS sclr_3 FROM exportation e0_ INNER JOIN commodite c1_ ON e0_.commodite_id = c1_.id INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id WHERE e0_.commodite_id = 1 GROUP BY c1_.nom, f2_.unite, sclr_3 ORDER BY sclr_3 ASC;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0,
  t1_.nom AS nom_1
FROM
  contrat_principal c0_
  INNER JOIN contrat_principal_type_contrat c2_ ON c0_.id = c2_.contrat_principal_id
  INNER JOIN type_contrat t1_ ON t1_.id = c2_.type_contrat_id
GROUP BY
  t1_.nom

SELECT COUNT(DISTINCT c0_.id) AS sclr_0, t1_.nom AS nom_1 FROM contrat_principal c0_ INNER JOIN contrat_principal_type_contrat c2_ ON c0_.id = c2_.contrat_principal_id INNER JOIN type_contrat t1_ ON t1_.id = c2_.type_contrat_id GROUP BY t1_.nom;

SELECT
  SUM(v0_.quantite) AS sclr_0,
  c1_.nom AS nom_1,
  f2_.unite AS unite_2,
  SUBSTRING(
    v0_.date_vente
    FROM
      6 FOR 2
  ) AS sclr_3
FROM
  vente_local v0_
  INNER JOIN commodite c1_ ON v0_.commodite_id = c1_.id
  INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id
WHERE
  (
    v0_.date_vente BETWEEN ?
    AND ?
  )
  AND v0_.commodite_id = ?
GROUP BY
  c1_.nom,
  f2_.unite,
  sclr_3
ORDER BY
  sclr_3 ASC

SELECT SUM(v0_.quantite) AS sclr_0, c1_.nom AS nom_1, f2_.unite AS unite_2, SUBSTRING(v0_.date_vente FROM 6 FOR 2) AS sclr_3 FROM vente_local v0_ INNER JOIN commodite c1_ ON v0_.commodite_id = c1_.id INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id 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 c1_.nom, f2_.unite, sclr_3 ORDER BY sclr_3 ASC;

SELECT
  SUM(p0_.quantite) AS sclr_0,
  c1_.nom AS nom_1,
  f2_.unite AS unite_2,
  SUBSTRING(
    p0_.date_production
    FROM
      6 FOR 2
  ) AS sclr_3
FROM
  production p0_
  INNER JOIN commodite c1_ ON p0_.commodite_id = c1_.id
  INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id
WHERE
  (
    p0_.date_production BETWEEN ?
    AND ?
  )
  AND p0_.commodite_id = ?
GROUP BY
  c1_.nom,
  f2_.unite,
  sclr_3
ORDER BY
  sclr_3 ASC

SELECT SUM(p0_.quantite) AS sclr_0, c1_.nom AS nom_1, f2_.unite AS unite_2, SUBSTRING(p0_.date_production FROM 6 FOR 2) AS sclr_3 FROM production p0_ INNER JOIN commodite c1_ ON p0_.commodite_id = c1_.id INNER JOIN filiere f2_ ON c1_.filiere_id = f2_.id WHERE (p0_.date_production BETWEEN '2018-01-01 00:00:00' AND '2018-12-31 23:59:00') AND p0_.commodite_id = 1 GROUP BY c1_.nom, f2_.unite, sclr_3 ORDER BY sclr_3 ASC;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  contrat_relatif c0_

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_relatif c0_;

SELECT
  SUM(d0_.montant) AS sclr_0,
  t1_.nom AS nom_1
FROM
  decaissement d0_
  INNER JOIN type_decaissement t1_ ON d0_.type_decaissement_id = t1_.id
GROUP BY
  t1_.nom

SELECT SUM(d0_.montant) AS sclr_0, t1_.nom AS nom_1 FROM decaissement d0_ INNER JOIN type_decaissement t1_ ON d0_.type_decaissement_id = t1_.id GROUP BY t1_.nom;

SELECT
  SUM(p0_.quantite) AS sclr_0,
  SUM(p0_.cout) AS sclr_1,
  SUBSTRING(
    p0_.date_production
    FROM
      1 FOR 4
  ) AS sclr_2
FROM
  production p0_
WHERE
  p0_.commodite_id = ?
GROUP BY
  sclr_2
ORDER BY
  sclr_2 DESC

SELECT SUM(p0_.quantite) AS sclr_0, SUM(p0_.cout) AS sclr_1, SUBSTRING(p0_.date_production FROM 1 FOR 4) AS sclr_2 FROM production p0_ WHERE p0_.commodite_id = 1 GROUP BY sclr_2 ORDER BY sclr_2 DESC;

SELECT
  SUM(t0_.montant) AS sclr_0,
  t1_.nom AS nom_1
FROM
  taxe t0_
  INNER JOIN type_taxe t1_ ON t0_.type_taxe_id = t1_.id
GROUP BY
  t1_.nom

SELECT SUM(t0_.montant) AS sclr_0, t1_.nom AS nom_1 FROM taxe t0_ INNER JOIN type_taxe t1_ ON t0_.type_taxe_id = t1_.id GROUP BY t1_.nom;

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
  SUM(i0_.nbre_feminin_local) AS sclr_0,
  SUM(i0_.nbre_masculin_local) AS sclr_1,
  SUM(i0_.nbre_cadre) AS sclr_2,
  SUM(i0_.nbre_ouvrier) AS sclr_3,
  SUM(i0_.nbre_feminin_etranger) AS sclr_4,
  SUM(i0_.nbre_masculin_etranger) AS sclr_5,
  SUBSTRING(
    i0_.date_info
    FROM
      1 FOR 4
  ) AS sclr_6
FROM
  information_emploi i0_
GROUP BY
  sclr_6
ORDER BY
  sclr_6 ASC

SELECT SUM(i0_.nbre_feminin_local) AS sclr_0, SUM(i0_.nbre_masculin_local) AS sclr_1, SUM(i0_.nbre_cadre) AS sclr_2, SUM(i0_.nbre_ouvrier) AS sclr_3, SUM(i0_.nbre_feminin_etranger) AS sclr_4, SUM(i0_.nbre_masculin_etranger) AS sclr_5, SUBSTRING(i0_.date_info FROM 1 FOR 4) AS sclr_6 FROM information_emploi i0_ GROUP BY sclr_6 ORDER BY sclr_6 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
  SUM(d0_.montant) AS sclr_0,
  t1_.nom AS nom_1
FROM
  depense_caisse d0_
  INNER JOIN type_decaissement t1_ ON d0_.type_depense_id = t1_.id
GROUP BY
  t1_.nom

SELECT SUM(d0_.montant) AS sclr_0, t1_.nom AS nom_1 FROM depense_caisse d0_ INNER JOIN type_decaissement t1_ ON d0_.type_depense_id = t1_.id GROUP BY t1_.nom;

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
  COUNT(DISTINCT t0_.id) AS sclr_0,
  t0_.type_permis AS type_permis_1
FROM
  titre_minier t0_
GROUP BY
  t0_.type_permis

SELECT COUNT(DISTINCT t0_.id) AS sclr_0, t0_.type_permis AS type_permis_1 FROM titre_minier t0_ GROUP BY t0_.type_permis;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  contrat_principal c0_

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_principal c0_;

SELECT
  SUM(p0_.montant) AS sclr_0,
  p0_.type_paiement AS type_paiement_1
FROM
  paiement p0_
GROUP BY
  p0_.type_paiement

SELECT SUM(p0_.montant) AS sclr_0, p0_.type_paiement AS type_paiement_1 FROM paiement p0_ GROUP BY p0_.type_paiement;

SELECT
  SUM(r0_.montant) AS sclr_0
FROM
  redevance r0_

SELECT SUM(r0_.montant) AS sclr_0 FROM redevance r0_;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.unite AS unite_3,
  t0.commodite_id AS commodite_id_4,
  t0.user_id AS user_id_5
FROM
  type_commodite t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.unite AS unite_3, t0.commodite_id AS commodite_id_4, t0.user_id AS user_id_5 FROM type_commodite t0;