Symfony Profiler

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 > '2024-01-01';

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 o0_.id) AS sclr_0,
  s1_.id AS id_1
FROM
  operateur o0_
  INNER JOIN sous_secteur s2_ ON o0_.sous_secteur_id = s2_.id
  INNER JOIN secteur s1_ ON s2_.secteur_id = s1_.id
WHERE
  o0_.annee_fermeture > ?
  AND o0_.date_creation < ?
GROUP BY
  s1_.id

SELECT COUNT(DISTINCT o0_.id) AS sclr_0, s1_.id AS id_1 FROM operateur o0_ INNER JOIN sous_secteur s2_ ON o0_.sous_secteur_id = s2_.id INNER JOIN secteur s1_ ON s2_.secteur_id = s1_.id WHERE o0_.annee_fermeture > '2024-01-01' AND o0_.date_creation < '2024-01-01' GROUP BY s1_.id;

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0,
  SUBSTRING(
    a0_.date_arrete
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  arrete a0_
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT COUNT(DISTINCT a0_.id) AS sclr_0, SUBSTRING(a0_.date_arrete FROM 1 FOR 4) AS sclr_1 FROM arrete a0_ GROUP BY sclr_1 ORDER BY sclr_1 ASC;

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0,
  a0_.categorie AS categorie_1
FROM
  arrete a0_
GROUP BY
  a0_.categorie

SELECT COUNT(DISTINCT a0_.id) AS sclr_0, a0_.categorie AS categorie_1 FROM arrete a0_ GROUP BY a0_.categorie;

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0,
  t1_.nom AS nom_1
FROM
  arrete a0_
  INNER JOIN type_arrete t1_ ON a0_.type_arrete_id = t1_.id
GROUP BY
  t1_.nom

SELECT COUNT(DISTINCT a0_.id) AS sclr_0, t1_.nom AS nom_1 FROM arrete a0_ INNER JOIN type_arrete t1_ ON a0_.type_arrete_id = t1_.id GROUP BY t1_.nom;

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0,
  o1_.denomination AS denomination_1
FROM
  arrete a0_
  INNER JOIN operateur o1_ ON a0_.operateur_id = o1_.id
GROUP BY
  o1_.denomination

SELECT COUNT(DISTINCT a0_.id) AS sclr_0, o1_.denomination AS denomination_1 FROM arrete a0_ INNER JOIN operateur o1_ ON a0_.operateur_id = o1_.id GROUP BY o1_.denomination;

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.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.operateur_id AS operateur_id_16,
  t0.province_id AS province_id_17,
  t0.user_id AS user_id_18
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.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.operateur_id AS operateur_id_16, t0.province_id AS province_id_17, t0.user_id AS user_id_18 FROM gisement t0;

SELECT
  COUNT(DISTINCT g0_.id) AS sclr_0,
  p1_.nom AS nom_1
FROM
  gisement g0_
  INNER JOIN province p1_ ON g0_.province_id = p1_.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 province p1_ ON g0_.province_id = p1_.id GROUP BY p1_.nom ORDER BY sclr_0 ASC;

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.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.operateur_id AS operateur_id_16,
  t0.province_id AS province_id_17,
  t0.user_id AS user_id_18
FROM
  gisement t0
ORDER BY
  t0.id ASC
LIMIT
  30

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.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.operateur_id AS operateur_id_16, t0.province_id AS province_id_17, t0.user_id AS user_id_18 FROM gisement t0 ORDER BY t0.id ASC LIMIT 30;

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.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.filiere_id AS filiere_id_9,
  t0.localisation_id AS localisation_id_10,
  t0.user_id AS user_id_11
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.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.filiere_id AS filiere_id_9, t0.localisation_id AS localisation_id_10, t0.user_id AS user_id_11 FROM commodite t0;

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
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  contrat_principal c0_

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

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 '2024-01-01 00:00:00' AND '2024-12-12 23:59:00';

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 '2024-09-01 00:00:00' AND '2024-09-30 23:59:00';

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 '2024-08-01 00:00:00' AND '2024-08-31 23:59:00';

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
WHERE
  o0_.annee_fermeture > ?
  AND o0_.date_creation < ?
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 WHERE o0_.annee_fermeture > '2024-01-01' AND o0_.date_creation < '2024-01-01' GROUP BY c1_.id, c1_.nom;

SELECT
  COUNT(DISTINCT i0_.id) AS sclr_0,
  p1_.libelle AS libelle_1
FROM
  investisseur i0_
  INNER JOIN pays p1_ ON i0_.pays_id = p1_.id
GROUP BY
  p1_.libelle

SELECT COUNT(DISTINCT i0_.id) AS sclr_0, p1_.libelle AS libelle_1 FROM investisseur i0_ INNER JOIN pays p1_ ON i0_.pays_id = p1_.id GROUP BY p1_.libelle;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0,
  p1_.libelle AS libelle_1
FROM
  proprietaire_reel p0_
  INNER JOIN pays p1_ ON p0_.pays_id = p1_.id
GROUP BY
  p1_.libelle

SELECT COUNT(DISTINCT p0_.id) AS sclr_0, p1_.libelle AS libelle_1 FROM proprietaire_reel p0_ INNER JOIN pays p1_ ON p0_.pays_id = p1_.id GROUP BY p1_.libelle;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0,
  o0_.service AS service_1
FROM
  operateur o0_
  INNER JOIN categorie c1_ ON o0_.categorie_id = c1_.id
WHERE
  c1_.id = ?
  AND o0_.service <> ?
GROUP BY
  o0_.service

SELECT COUNT(DISTINCT o0_.id) AS sclr_0, o0_.service AS service_1 FROM operateur o0_ INNER JOIN categorie c1_ ON o0_.categorie_id = c1_.id WHERE c1_.id = 10 AND o0_.service <> 'Aucun' GROUP BY o0_.service;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0,
  SUBSTRING(
    p0_.date_debut
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  projet_dot p0_
GROUP BY
  sclr_1
ORDER BY
  sclr_1 ASC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0, SUBSTRING(p0_.date_debut FROM 1 FOR 4) AS sclr_1 FROM projet_dot p0_ GROUP BY sclr_1 ORDER BY sclr_1 ASC;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0,
  SUBSTRING(
    p0_.date_debut
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  projet_dot p0_
WHERE
  p0_.stade = ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 DESC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0, SUBSTRING(p0_.date_debut FROM 1 FOR 4) AS sclr_1 FROM projet_dot p0_ WHERE p0_.stade = 'Terminé' GROUP BY sclr_1 ORDER BY sclr_1 DESC;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0,
  SUBSTRING(
    p0_.date_debut
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  projet_dot p0_
WHERE
  p0_.stade = ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 DESC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0, SUBSTRING(p0_.date_debut FROM 1 FOR 4) AS sclr_1 FROM projet_dot p0_ WHERE p0_.stade = 'Non terminé' GROUP BY sclr_1 ORDER BY sclr_1 DESC;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0,
  SUBSTRING(
    p0_.date_debut
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  projet_dot p0_
WHERE
  p0_.stade = ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 DESC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0, SUBSTRING(p0_.date_debut FROM 1 FOR 4) AS sclr_1 FROM projet_dot p0_ WHERE p0_.stade = 'Non exécuté' GROUP BY sclr_1 ORDER BY sclr_1 DESC;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0,
  p0_.type_projet AS type_projet_1,
  SUBSTRING(
    p0_.date_projet
    FROM
      1 FOR 4
  ) AS sclr_2
FROM
  projet p0_
GROUP BY
  sclr_2,
  p0_.type_projet
ORDER BY
  sclr_2 DESC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0, p0_.type_projet AS type_projet_1, SUBSTRING(p0_.date_projet FROM 1 FOR 4) AS sclr_2 FROM projet p0_ GROUP BY sclr_2, p0_.type_projet ORDER BY sclr_2 DESC;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0,
  SUBSTRING(
    p0_.date_debut
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  projet_cahier_de_charge p0_
GROUP BY
  sclr_1
ORDER BY
  sclr_1 DESC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0, SUBSTRING(p0_.date_debut FROM 1 FOR 4) AS sclr_1 FROM projet_cahier_de_charge p0_ GROUP BY sclr_1 ORDER BY sclr_1 DESC;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0,
  SUBSTRING(
    p0_.date_debut
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  projet_dot p0_
WHERE
  p0_.stade = ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 DESC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0, SUBSTRING(p0_.date_debut FROM 1 FOR 4) AS sclr_1 FROM projet_dot p0_ WHERE p0_.stade = 'Terminé' GROUP BY sclr_1 ORDER BY sclr_1 DESC;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0,
  SUBSTRING(
    p0_.date_debut
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  projet_dot p0_
WHERE
  p0_.stade = ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 DESC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0, SUBSTRING(p0_.date_debut FROM 1 FOR 4) AS sclr_1 FROM projet_dot p0_ WHERE p0_.stade = 'Non terminé' GROUP BY sclr_1 ORDER BY sclr_1 DESC;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0,
  SUBSTRING(
    p0_.date_debut
    FROM
      1 FOR 4
  ) AS sclr_1
FROM
  projet_dot p0_
WHERE
  p0_.stade = ?
GROUP BY
  sclr_1
ORDER BY
  sclr_1 DESC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0, SUBSTRING(p0_.date_debut FROM 1 FOR 4) AS sclr_1 FROM projet_dot p0_ WHERE p0_.stade = 'Non exécuté' GROUP BY sclr_1 ORDER BY sclr_1 DESC;

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 '2024-01-01 00:00:00' AND '2024-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 '2024-01-01 00:00:00' AND '2024-12-31 23:59:00') AND p0_.commodite_id = 1 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 ?
    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 '2024-01-01 00:00:00' AND '2024-12-31 23:59:00') AND e0_.commodite_id = 1 GROUP BY c1_.nom, f2_.unite, sclr_3 ORDER BY sclr_3 ASC;