Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.entity AS entity_3,
  t0.value AS value_4
FROM
  permission t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 138;

SELECT
  v0_.id AS id_0,
  v0_.ref AS ref_1,
  v0_.date AS date_2,
  v0_.index_ouverture AS index_ouverture_3,
  v0_.index_cloture AS index_cloture_4,
  v0_.retour_en_cuve AS retour_en_cuve_5,
  v0_.vente AS vente_6,
  v0_.ca AS ca_7,
  v0_.jauge_ouverture AS jauge_ouverture_8,
  v0_.jauge_cloture AS jauge_cloture_9,
  v0_.stock_theorique AS stock_theorique_10,
  v0_.ecart AS ecart_11,
  v0_.stock_cuve_restant AS stock_cuve_restant_12,
  v0_.commentaire AS commentaire_13,
  v0_.statut AS statut_14,
  v0_.motif_rejet AS motif_rejet_15,
  v0_.counter_year AS counter_year_16,
  v0_.created_at AS created_at_17,
  v0_.updated_at AS updated_at_18,
  d1_.id AS id_19,
  d1_.index_ouverture AS index_ouverture_20,
  d1_.index_cloture AS index_cloture_21,
  d1_.retour_en_cuve AS retour_en_cuve_22,
  d1_.produit_vendu AS produit_vendu_23,
  d1_.ca AS ca_24,
  d1_.product_name AS product_name_25,
  d1_.jauge_ouverture AS jauge_ouverture_26,
  d1_.jauge_cloture AS jauge_cloture_27,
  d1_.stock_restant AS stock_restant_28,
  d1_.stock_vendu AS stock_vendu_29,
  d1_.type AS type_30,
  d1_.stock_reception AS stock_reception_31,
  d1_.stock_cuve_av_vente AS stock_cuve_av_vente_32,
  d1_.created_at AS created_at_33,
  d1_.updated_at AS updated_at_34,
  v0_.operation_user_id AS operation_user_id_35,
  v0_.station_id AS station_id_36,
  d1_.pompe_id AS pompe_id_37,
  d1_.vente_id AS vente_id_38,
  d1_.cuve_id AS cuve_id_39
FROM
  vente v0_
  LEFT JOIN details_vente d1_ ON v0_.id = d1_.vente_id
WHERE
  YEAR(v0_.date) = YEAR(CURRENT_DATE)
ORDER BY
  v0_.date ASC

SELECT v0_.id AS id_0, v0_.ref AS ref_1, v0_.date AS date_2, v0_.index_ouverture AS index_ouverture_3, v0_.index_cloture AS index_cloture_4, v0_.retour_en_cuve AS retour_en_cuve_5, v0_.vente AS vente_6, v0_.ca AS ca_7, v0_.jauge_ouverture AS jauge_ouverture_8, v0_.jauge_cloture AS jauge_cloture_9, v0_.stock_theorique AS stock_theorique_10, v0_.ecart AS ecart_11, v0_.stock_cuve_restant AS stock_cuve_restant_12, v0_.commentaire AS commentaire_13, v0_.statut AS statut_14, v0_.motif_rejet AS motif_rejet_15, v0_.counter_year AS counter_year_16, v0_.created_at AS created_at_17, v0_.updated_at AS updated_at_18, d1_.id AS id_19, d1_.index_ouverture AS index_ouverture_20, d1_.index_cloture AS index_cloture_21, d1_.retour_en_cuve AS retour_en_cuve_22, d1_.produit_vendu AS produit_vendu_23, d1_.ca AS ca_24, d1_.product_name AS product_name_25, d1_.jauge_ouverture AS jauge_ouverture_26, d1_.jauge_cloture AS jauge_cloture_27, d1_.stock_restant AS stock_restant_28, d1_.stock_vendu AS stock_vendu_29, d1_.type AS type_30, d1_.stock_reception AS stock_reception_31, d1_.stock_cuve_av_vente AS stock_cuve_av_vente_32, d1_.created_at AS created_at_33, d1_.updated_at AS updated_at_34, v0_.operation_user_id AS operation_user_id_35, v0_.station_id AS station_id_36, d1_.pompe_id AS pompe_id_37, d1_.vente_id AS vente_id_38, d1_.cuve_id AS cuve_id_39 FROM vente v0_ LEFT JOIN details_vente d1_ ON v0_.id = d1_.vente_id WHERE YEAR(v0_.date) = YEAR(CURRENT_DATE) ORDER BY v0_.date ASC;

SELECT
  v0_.id AS id_0,
  v0_.montant AS montant_1,
  v0_.date AS date_2,
  v0_.reference AS reference_3,
  v0_.justificatif AS justificatif_4,
  v0_.commentaire AS commentaire_5,
  v0_.statut AS statut_6,
  v0_.motif_rejet AS motif_rejet_7,
  v0_.type AS type_8,
  v0_.date_debut AS date_debut_9,
  v0_.date_fin AS date_fin_10,
  v0_.created_at AS created_at_11,
  v0_.updated_at AS updated_at_12,
  v0_.station_id AS station_id_13,
  v0_.banque_id AS banque_id_14,
  v0_.operation_user_id AS operation_user_id_15
FROM
  versement v0_
WHERE
  v0_.date BETWEEN ?
  AND ?
ORDER BY
  v0_.date DESC

SELECT v0_.id AS id_0, v0_.montant AS montant_1, v0_.date AS date_2, v0_.reference AS reference_3, v0_.justificatif AS justificatif_4, v0_.commentaire AS commentaire_5, v0_.statut AS statut_6, v0_.motif_rejet AS motif_rejet_7, v0_.type AS type_8, v0_.date_debut AS date_debut_9, v0_.date_fin AS date_fin_10, v0_.created_at AS created_at_11, v0_.updated_at AS updated_at_12, v0_.station_id AS station_id_13, v0_.banque_id AS banque_id_14, v0_.operation_user_id AS operation_user_id_15 FROM versement v0_ WHERE v0_.date BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59' ORDER BY v0_.date DESC;

SELECT
  v0_.id AS id_0,
  v0_.montant AS montant_1,
  v0_.date AS date_2,
  v0_.reference AS reference_3,
  v0_.justificatif AS justificatif_4,
  v0_.commentaire AS commentaire_5,
  v0_.statut AS statut_6,
  v0_.motif_rejet AS motif_rejet_7,
  v0_.type AS type_8,
  v0_.date_debut AS date_debut_9,
  v0_.date_fin AS date_fin_10,
  v0_.created_at AS created_at_11,
  v0_.updated_at AS updated_at_12,
  s1_.id AS id_13,
  s1_.libelle AS libelle_14,
  s1_.ref_client AS ref_client_15,
  s1_.latitude AS latitude_16,
  s1_.longitude AS longitude_17,
  s1_.created_at AS created_at_18,
  s1_.updated_at AS updated_at_19,
  b2_.id AS id_20,
  b2_.name AS name_21,
  b2_.code AS code_22,
  b2_.numero_compte AS numero_compte_23,
  b2_.statut AS statut_24,
  b2_.created_at AS created_at_25,
  b2_.updated_at AS updated_at_26,
  v0_.station_id AS station_id_27,
  v0_.banque_id AS banque_id_28,
  v0_.operation_user_id AS operation_user_id_29,
  s1_.localite_id AS localite_id_30
FROM
  versement v0_
  LEFT JOIN station_service s1_ ON v0_.station_id = s1_.id
  LEFT JOIN banque b2_ ON v0_.banque_id = b2_.id
ORDER BY
  v0_.date DESC
LIMIT
  8

SELECT v0_.id AS id_0, v0_.montant AS montant_1, v0_.date AS date_2, v0_.reference AS reference_3, v0_.justificatif AS justificatif_4, v0_.commentaire AS commentaire_5, v0_.statut AS statut_6, v0_.motif_rejet AS motif_rejet_7, v0_.type AS type_8, v0_.date_debut AS date_debut_9, v0_.date_fin AS date_fin_10, v0_.created_at AS created_at_11, v0_.updated_at AS updated_at_12, s1_.id AS id_13, s1_.libelle AS libelle_14, s1_.ref_client AS ref_client_15, s1_.latitude AS latitude_16, s1_.longitude AS longitude_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, b2_.id AS id_20, b2_.name AS name_21, b2_.code AS code_22, b2_.numero_compte AS numero_compte_23, b2_.statut AS statut_24, b2_.created_at AS created_at_25, b2_.updated_at AS updated_at_26, v0_.station_id AS station_id_27, v0_.banque_id AS banque_id_28, v0_.operation_user_id AS operation_user_id_29, s1_.localite_id AS localite_id_30 FROM versement v0_ LEFT JOIN station_service s1_ ON v0_.station_id = s1_.id LEFT JOIN banque b2_ ON v0_.banque_id = b2_.id ORDER BY v0_.date DESC LIMIT 8;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.fonction AS fonction_5,
  t0.photo AS photo_6,
  t0.roles AS roles_7,
  t0.refresh_token AS refresh_token_8,
  t0.refresh_token_expires_at AS refresh_token_expires_at_9,
  t0.apps AS apps_10,
  t0.signature AS signature_11,
  t0.fleet_refresh_token AS fleet_refresh_token_12,
  t0.password AS password_13,
  t0.slug AS slug_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.station_id AS station_id_17,
  t0.lieu_empotage_id AS lieu_empotage_id_18
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.fonction AS fonction_5, t0.photo AS photo_6, t0.roles AS roles_7, t0.refresh_token AS refresh_token_8, t0.refresh_token_expires_at AS refresh_token_expires_at_9, t0.apps AS apps_10, t0.signature AS signature_11, t0.fleet_refresh_token AS fleet_refresh_token_12, t0.password AS password_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.station_id AS station_id_17, t0.lieu_empotage_id AS lieu_empotage_id_18 FROM `user` t0 WHERE t0.id = 21;

SELECT
  c0_.id AS id_0,
  c0_.ref AS ref_1,
  c0_.litrage AS litrage_2,
  c0_.montant_accorde AS montant_accorde_3,
  c0_.montant_restant AS montant_restant_4,
  c0_.date AS date_5,
  c0_.echeance AS echeance_6,
  c0_.motif AS motif_7,
  c0_.statut AS statut_8,
  c0_.validation_statut AS validation_statut_9,
  c0_.motif_rejet AS motif_rejet_10,
  c0_.nature AS nature_11,
  c0_.immatriculation AS immatriculation_12,
  c0_.with_echeance AS with_echeance_13,
  c0_.camion_id AS camion_id_14,
  c0_.vehicule_id AS vehicule_id_15,
  c0_.counter_year AS counter_year_16,
  c0_.slug AS slug_17,
  c0_.created_at AS created_at_18,
  c0_.updated_at AS updated_at_19,
  c0_.client_id AS client_id_20,
  c0_.station_id AS station_id_21,
  c0_.produit_id AS produit_id_22,
  c0_.operation_user_id AS operation_user_id_23,
  c0_.type_credit_id AS type_credit_id_24,
  c0_.pompiste_id AS pompiste_id_25
FROM
  credit c0_
WHERE
  c0_.date BETWEEN ?
  AND ?

SELECT c0_.id AS id_0, c0_.ref AS ref_1, c0_.litrage AS litrage_2, c0_.montant_accorde AS montant_accorde_3, c0_.montant_restant AS montant_restant_4, c0_.date AS date_5, c0_.echeance AS echeance_6, c0_.motif AS motif_7, c0_.statut AS statut_8, c0_.validation_statut AS validation_statut_9, c0_.motif_rejet AS motif_rejet_10, c0_.nature AS nature_11, c0_.immatriculation AS immatriculation_12, c0_.with_echeance AS with_echeance_13, c0_.camion_id AS camion_id_14, c0_.vehicule_id AS vehicule_id_15, c0_.counter_year AS counter_year_16, c0_.slug AS slug_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.client_id AS client_id_20, c0_.station_id AS station_id_21, c0_.produit_id AS produit_id_22, c0_.operation_user_id AS operation_user_id_23, c0_.type_credit_id AS type_credit_id_24, c0_.pompiste_id AS pompiste_id_25 FROM credit c0_ WHERE c0_.date BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59';

SELECT
  DATE_FORMAT(r0_.date, '%Y-%m') AS sclr_0,
  DATE_FORMAT(r0_.date, '%b %y') AS sclr_1,
  SUM(r0_.montant) AS sclr_2
FROM
  regelement_credit r0_
WHERE
  r0_.date >= ?
GROUP BY
  sclr_0,
  sclr_1
ORDER BY
  sclr_0 ASC

SELECT DATE_FORMAT(r0_.date, '%Y-%m') AS sclr_0, DATE_FORMAT(r0_.date, '%b %y') AS sclr_1, SUM(r0_.montant) AS sclr_2 FROM regelement_credit r0_ WHERE r0_.date >= '2026-03-24 14:55:19' GROUP BY sclr_0, sclr_1 ORDER BY sclr_0 ASC;

SELECT
  c0_.raison_sociale AS raison_sociale_0,
  SUM(c1_.montant_accorde) AS sclr_1,
  COALESCE(
    SUM(c1_.montant_restant),
    0
  ) AS sclr_2
FROM
  credit c1_
  INNER JOIN client c0_ ON c1_.client_id = c0_.id
WHERE
  c1_.statut IN (?, ?)
GROUP BY
  c0_.id,
  c0_.raison_sociale
ORDER BY
  sclr_1 DESC
LIMIT
  6

SELECT c0_.raison_sociale AS raison_sociale_0, SUM(c1_.montant_accorde) AS sclr_1, COALESCE(SUM(c1_.montant_restant), 0) AS sclr_2 FROM credit c1_ INNER JOIN client c0_ ON c1_.client_id = c0_.id WHERE c1_.statut IN ('actif', 'en_retard') GROUP BY c0_.id, c0_.raison_sociale ORDER BY sclr_1 DESC LIMIT 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  role t0
  INNER JOIN role_user ON t0.id = role_user.role_id
WHERE
  role_user.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = 21;

SELECT
  b0_.name AS name_0,
  COALESCE(
    SUM(v1_.montant),
    0
  ) AS sclr_1
FROM
  versement v1_
  INNER JOIN banque b0_ ON v1_.banque_id = b0_.id
WHERE
  v1_.statut = ?
GROUP BY
  b0_.id,
  b0_.name
ORDER BY
  sclr_1 DESC
LIMIT
  10

SELECT b0_.name AS name_0, COALESCE(SUM(v1_.montant), 0) AS sclr_1 FROM versement v1_ INNER JOIN banque b0_ ON v1_.banque_id = b0_.id WHERE v1_.statut = 'valide' GROUP BY b0_.id, b0_.name ORDER BY sclr_1 DESC LIMIT 10;

SELECT
  v0_.id AS id_0,
  v0_.ref AS ref_1,
  v0_.date AS date_2,
  v0_.index_ouverture AS index_ouverture_3,
  v0_.index_cloture AS index_cloture_4,
  v0_.retour_en_cuve AS retour_en_cuve_5,
  v0_.vente AS vente_6,
  v0_.ca AS ca_7,
  v0_.jauge_ouverture AS jauge_ouverture_8,
  v0_.jauge_cloture AS jauge_cloture_9,
  v0_.stock_theorique AS stock_theorique_10,
  v0_.ecart AS ecart_11,
  v0_.stock_cuve_restant AS stock_cuve_restant_12,
  v0_.commentaire AS commentaire_13,
  v0_.statut AS statut_14,
  v0_.motif_rejet AS motif_rejet_15,
  v0_.counter_year AS counter_year_16,
  v0_.created_at AS created_at_17,
  v0_.updated_at AS updated_at_18,
  s1_.id AS id_19,
  s1_.libelle AS libelle_20,
  s1_.ref_client AS ref_client_21,
  s1_.latitude AS latitude_22,
  s1_.longitude AS longitude_23,
  s1_.created_at AS created_at_24,
  s1_.updated_at AS updated_at_25,
  v0_.operation_user_id AS operation_user_id_26,
  v0_.station_id AS station_id_27,
  s1_.localite_id AS localite_id_28
FROM
  vente v0_
  LEFT JOIN station_service s1_ ON v0_.station_id = s1_.id
ORDER BY
  v0_.date DESC,
  v0_.id DESC
LIMIT
  8

SELECT v0_.id AS id_0, v0_.ref AS ref_1, v0_.date AS date_2, v0_.index_ouverture AS index_ouverture_3, v0_.index_cloture AS index_cloture_4, v0_.retour_en_cuve AS retour_en_cuve_5, v0_.vente AS vente_6, v0_.ca AS ca_7, v0_.jauge_ouverture AS jauge_ouverture_8, v0_.jauge_cloture AS jauge_cloture_9, v0_.stock_theorique AS stock_theorique_10, v0_.ecart AS ecart_11, v0_.stock_cuve_restant AS stock_cuve_restant_12, v0_.commentaire AS commentaire_13, v0_.statut AS statut_14, v0_.motif_rejet AS motif_rejet_15, v0_.counter_year AS counter_year_16, v0_.created_at AS created_at_17, v0_.updated_at AS updated_at_18, s1_.id AS id_19, s1_.libelle AS libelle_20, s1_.ref_client AS ref_client_21, s1_.latitude AS latitude_22, s1_.longitude AS longitude_23, s1_.created_at AS created_at_24, s1_.updated_at AS updated_at_25, v0_.operation_user_id AS operation_user_id_26, v0_.station_id AS station_id_27, s1_.localite_id AS localite_id_28 FROM vente v0_ LEFT JOIN station_service s1_ ON v0_.station_id = s1_.id ORDER BY v0_.date DESC, v0_.id DESC LIMIT 8;

SELECT
  t0.id AS id_1,
  t0.entity AS entity_2,
  t0.role_id AS role_id_3,
  t0.permission_id AS permission_id_4
FROM
  role_permission t0
WHERE
  t0.role_id = ?

SELECT t0.id AS id_1, t0.entity AS entity_2, t0.role_id AS role_id_3, t0.permission_id AS permission_id_4 FROM role_permission t0 WHERE t0.role_id = 2;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.need_camion AS need_camion_3,
  t0.need_vehicule AS need_vehicule_4,
  t0.need_litrage_field AS need_litrage_field_5,
  t0.need_pompiste AS need_pompiste_6,
  t0.need_motif AS need_motif_7,
  t0.need_immatriculation_field AS need_immatriculation_field_8,
  t0.need_nature_field AS need_nature_field_9
FROM
  type_credit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.need_camion AS need_camion_3, t0.need_vehicule AS need_vehicule_4, t0.need_litrage_field AS need_litrage_field_5, t0.need_pompiste AS need_pompiste_6, t0.need_motif AS need_motif_7, t0.need_immatriculation_field AS need_immatriculation_field_8, t0.need_nature_field AS need_nature_field_9 FROM type_credit t0 WHERE t0.id = 1;

SELECT
  DATE_FORMAT(v0_.date, '%Y-%m') AS sclr_0,
  DATE_FORMAT(v0_.date, '%b %Y') AS sclr_1,
  COALESCE(
    SUM(v0_.montant),
    0
  ) AS sclr_2
FROM
  versement v0_
WHERE
  v0_.statut = ?
  AND v0_.date >= ?
GROUP BY
  sclr_0,
  sclr_1
ORDER BY
  sclr_0 ASC

SELECT DATE_FORMAT(v0_.date, '%Y-%m') AS sclr_0, DATE_FORMAT(v0_.date, '%b %Y') AS sclr_1, COALESCE(SUM(v0_.montant), 0) AS sclr_2 FROM versement v0_ WHERE v0_.statut = 'valide' AND v0_.date >= '2025-09-24 14:55:19' GROUP BY sclr_0, sclr_1 ORDER BY sclr_0 ASC;

SELECT
  p0_.libelle AS libelle_0,
  p1_.prix AS prix_1
FROM
  prix_produit p1_
  LEFT JOIN produit p0_ ON (p0_.id = p1_.produit_id)
WHERE
  YEAR(p1_.date) = ?
  AND MONTH(p1_.date) = ?

SELECT p0_.libelle AS libelle_0, p1_.prix AS prix_1 FROM prix_produit p1_ LEFT JOIN produit p0_ ON (p0_.id = p1_.produit_id) WHERE YEAR(p1_.date) = 2026 AND MONTH(p1_.date) = 9;

SELECT
  c0_.raison_sociale AS raison_sociale_0,
  c0_.cumule_credit AS cumule_credit_1,
  c0_.plafond_credit AS plafond_credit_2
FROM
  credit c1_
  INNER JOIN client c0_ ON c1_.client_id = c0_.id
WHERE
  c1_.statut = ?
  AND c0_.plafond_credit > 0
GROUP BY
  c0_.id,
  c0_.raison_sociale,
  c0_.cumule_credit,
  c0_.plafond_credit
ORDER BY
  c0_.cumule_credit DESC
LIMIT
  10

SELECT c0_.raison_sociale AS raison_sociale_0, c0_.cumule_credit AS cumule_credit_1, c0_.plafond_credit AS plafond_credit_2 FROM credit c1_ INNER JOIN client c0_ ON c1_.client_id = c0_.id WHERE c1_.statut = 'actif' AND c0_.plafond_credit > 0 GROUP BY c0_.id, c0_.raison_sociale, c0_.cumule_credit, c0_.plafond_credit ORDER BY c0_.cumule_credit DESC LIMIT 10;

SELECT
  COUNT(DISTINCT c0_.client_id) AS sclr_0
FROM
  credit c0_
WHERE
  c0_.statut = ?

SELECT COUNT(DISTINCT c0_.client_id) AS sclr_0 FROM credit c0_ WHERE c0_.statut = 'actif';

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  credit c0_
WHERE
  c0_.statut IN (?, ?)
  AND c0_.echeance < ?

SELECT COUNT(c0_.id) AS sclr_0 FROM credit c0_ WHERE c0_.statut IN ('actif', 'en_retard') AND c0_.echeance < '2026-09-24 14:55:19';

SELECT
  DATE_FORMAT(r0_.date, '%Y-%m') AS sclr_0,
  SUM(c1_.montant_accorde) AS sclr_1
FROM
  regelement_credit r0_
  INNER JOIN credit c1_ ON r0_.credit_id = c1_.id
WHERE
  r0_.date >= ?
GROUP BY
  sclr_0

SELECT DATE_FORMAT(r0_.date, '%Y-%m') AS sclr_0, SUM(c1_.montant_accorde) AS sclr_1 FROM regelement_credit r0_ INNER JOIN credit c1_ ON r0_.credit_id = c1_.id WHERE r0_.date >= '2026-03-24 14:55:19' GROUP BY sclr_0;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  credit c0_
WHERE
  c0_.statut = ?
  AND c0_.echeance >= ?
  AND c0_.echeance <= ?

SELECT COUNT(c0_.id) AS sclr_0 FROM credit c0_ WHERE c0_.statut = 'actif' AND c0_.echeance >= '2026-09-24 14:55:19' AND c0_.echeance <= '2026-10-08 14:55:19';