Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.montant AS montant_2,
  t0.date_operation AS date_operation_3,
  t0.motif AS motif_4,
  t0.flag_compassation AS flag_compassation_5,
  t0.fichier_banque AS fichier_banque_6,
  t0.id_cmd_id AS id_cmd_id_7,
  t0.id_ag_id AS id_ag_id_8
FROM
  reduction t0
WHERE
  t0.id_cmd_id = ?

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.date_operation AS date_operation_3, t0.motif AS motif_4, t0.flag_compassation AS flag_compassation_5, t0.fichier_banque AS fichier_banque_6, t0.id_cmd_id AS id_cmd_id_7, t0.id_ag_id AS id_ag_id_8 FROM reduction t0 WHERE t0.id_cmd_id = 7930178;

SELECT
  *,
  c.id AS idCommande,
  (
    SELECT
      nom_ag
    FROM
      agent a
    WHERE
      a.id = c.id_cl_id
  ) AS nom_client,
  (
    SELECT
      IFNULL(
        SUM(
          ROUND(tV.prix_unit * tV.volume)
        ),
        0
      )
    FROM
      tmp_volume tV
    WHERE
      c.id = tV.commande_id
  ) AS pritotal,
  (
    SELECT
      MAX(p.id) AS maxid
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
  ) AS idFacture,
  (
    SELECT
      IFNULL(
        SUM(p.montant),
        0
      )
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
      AND p.flag_en_avance = 0
  ) AS dejaPaie,
  (
    SELECT
      IFNULL(
        SUM(p.montant),
        0
      )
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
      AND p.flag_en_avance = 1
  ) AS paieEnAvance,
  (
    SELECT
      IFNULL(
        SUM(atF.montant),
        0
      )
    FROM
      autre_frais atF
    WHERE
      atF.commande_id = c.id
  ) AS AutresFrais,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '0'
  ) AS reduction,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '1'
  ) AS compassation,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '2'
  ) AS banque,
  (
    SELECT
      r.montant
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '2'
    ORDER BY
      r.id DESC
    LIMIT
      1
  ) AS banqueDujour,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '3'
  ) AS depot
FROM
  commande c
  LEFT JOIN agent a ON (c.id_ag_id = a.id)
  LEFT JOIN programme_contenaire ctpr ON (c.id_ct_pr_id = ctpr.id)
  LEFT JOIN contenaire ct ON (ctpr.id_ct_id = ct.id)
WHERE
  c.id = 7920619
ORDER BY
  c.id DESC

SELECT *,c.id AS idCommande, 
                    (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, 
                    (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,
                    (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,
                    (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,
                    (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,
                    (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,
                    (SELECT r.montant FROM reduction r  WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ORDER BY r.id DESC LIMIT 1) AS banqueDujour,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot
                    FROM commande c LEFT JOIN  agent a ON (c.id_ag_id = a.id) LEFT JOIN  programme_contenaire ctpr ON (c.id_ct_pr_id = ctpr.id) LEFT JOIN contenaire ct ON (ctpr.id_ct_id = ct.id) WHERE c.id = 7920619 ORDER BY  c.id DESC;

SELECT
  c0_.id AS id_0,
  c0_.date_commande AS date_commande_1,
  c0_.alias_client AS alias_client_2,
  c0_.recu_cargo AS recu_cargo_3,
  c0_.qte_print AS qte_print_4,
  c0_.contact AS contact_5,
  c0_.facturehors AS facturehors_6,
  c0_.nouvelle_facture AS nouvelle_facture_7,
  c0_.facture_marchandise_abscent AS facture_marchandise_abscent_8,
  c0_.is_paid AS is_paid_9,
  c0_.modification AS modification_10,
  c0_.remarque AS remarque_11,
  c0_.flagflutter_notification AS flagflutter_notification_12,
  c0_.pkg AS pkg_13,
  c0_.ville AS ville_14,
  c0_.is_number_verified AS is_number_verified_15,
  c0_.remarque_depot AS remarque_depot_16,
  c0_.is_scanned AS is_scanned_17,
  c0_.p1 AS p1_18,
  c0_.p2 AS p2_19,
  c0_.p3 AS p3_20,
  c0_.p4 AS p4_21,
  c0_.p5 AS p5_22,
  c0_.p6 AS p6_23,
  c0_.date_p1 AS date_p1_24,
  c0_.date_p2 AS date_p2_25,
  c0_.date_p3 AS date_p3_26,
  c0_.date_p4 AS date_p4_27,
  c0_.date_p5 AS date_p5_28,
  c0_.date_p6 AS date_p6_29,
  c0_.id_ag_id AS id_ag_id_30,
  c0_.id_cl_id AS id_cl_id_31,
  c0_.id_ct_pr_id AS id_ct_pr_id_32
FROM
  commande c0_
  INNER JOIN programme_contenaire p1_ ON c0_.id_ct_pr_id = p1_.id
WHERE
  c0_.contact = ?
  AND p1_.validation = ?
ORDER BY
  c0_.date_commande DESC
LIMIT
  100

SELECT c0_.id AS id_0, c0_.date_commande AS date_commande_1, c0_.alias_client AS alias_client_2, c0_.recu_cargo AS recu_cargo_3, c0_.qte_print AS qte_print_4, c0_.contact AS contact_5, c0_.facturehors AS facturehors_6, c0_.nouvelle_facture AS nouvelle_facture_7, c0_.facture_marchandise_abscent AS facture_marchandise_abscent_8, c0_.is_paid AS is_paid_9, c0_.modification AS modification_10, c0_.remarque AS remarque_11, c0_.flagflutter_notification AS flagflutter_notification_12, c0_.pkg AS pkg_13, c0_.ville AS ville_14, c0_.is_number_verified AS is_number_verified_15, c0_.remarque_depot AS remarque_depot_16, c0_.is_scanned AS is_scanned_17, c0_.p1 AS p1_18, c0_.p2 AS p2_19, c0_.p3 AS p3_20, c0_.p4 AS p4_21, c0_.p5 AS p5_22, c0_.p6 AS p6_23, c0_.date_p1 AS date_p1_24, c0_.date_p2 AS date_p2_25, c0_.date_p3 AS date_p3_26, c0_.date_p4 AS date_p4_27, c0_.date_p5 AS date_p5_28, c0_.date_p6 AS date_p6_29, c0_.id_ag_id AS id_ag_id_30, c0_.id_cl_id AS id_cl_id_31, c0_.id_ct_pr_id AS id_ct_pr_id_32 FROM commande c0_ INNER JOIN programme_contenaire p1_ ON c0_.id_ct_pr_id = p1_.id WHERE c0_.contact = '243842533990' AND p1_.validation = 1 ORDER BY c0_.date_commande DESC LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.date_chargement AS date_chargement_2,
  t0.date_depart AS date_depart_3,
  t0.date_arriver AS date_arriver_4,
  t0.date_operation AS date_operation_5,
  t0.nom_bateau AS nom_bateau_6,
  t0.id_ag AS id_ag_7,
  t0.flag AS flag_8,
  t0.numero_contenaire AS numero_contenaire_9,
  t0.transporteur AS transporteur_10,
  t0.complet_flag AS complet_flag_11,
  t0.proprietaire_conteneur AS proprietaire_conteneur_12,
  t0.destination AS destination_13,
  t0.validation AS validation_14,
  t0.depenses_prevue AS depenses_prevue_15,
  t0.remarque_conteneur AS remarque_conteneur_16,
  t0.is_mco AS is_mco_17,
  t0.is_rapport AS is_rapport_18,
  t0.date_rapport_at AS date_rapport_at_19,
  t0.is_clients AS is_clients_20,
  t0.rapport AS rapport_21,
  t0.is_electronique AS is_electronique_22,
  t0.date_validation AS date_validation_23,
  t0.is_notifier AS is_notifier_24,
  t0.fin AS fin_25,
  t0.date_validation_fin AS date_validation_fin_26,
  t0.dateattribution AS dateattribution_27,
  t0.paye_gestionnaire AS paye_gestionnaire_28,
  t0.id_ct_id AS id_ct_id_29,
  t0.id_ville_id AS id_ville_id_30,
  t0.ville_initiale_id AS ville_initiale_id_31,
  t0.agent_gestionnaire_id AS agent_gestionnaire_id_32
FROM
  programme_contenaire t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_chargement AS date_chargement_2, t0.date_depart AS date_depart_3, t0.date_arriver AS date_arriver_4, t0.date_operation AS date_operation_5, t0.nom_bateau AS nom_bateau_6, t0.id_ag AS id_ag_7, t0.flag AS flag_8, t0.numero_contenaire AS numero_contenaire_9, t0.transporteur AS transporteur_10, t0.complet_flag AS complet_flag_11, t0.proprietaire_conteneur AS proprietaire_conteneur_12, t0.destination AS destination_13, t0.validation AS validation_14, t0.depenses_prevue AS depenses_prevue_15, t0.remarque_conteneur AS remarque_conteneur_16, t0.is_mco AS is_mco_17, t0.is_rapport AS is_rapport_18, t0.date_rapport_at AS date_rapport_at_19, t0.is_clients AS is_clients_20, t0.rapport AS rapport_21, t0.is_electronique AS is_electronique_22, t0.date_validation AS date_validation_23, t0.is_notifier AS is_notifier_24, t0.fin AS fin_25, t0.date_validation_fin AS date_validation_fin_26, t0.dateattribution AS dateattribution_27, t0.paye_gestionnaire AS paye_gestionnaire_28, t0.id_ct_id AS id_ct_id_29, t0.id_ville_id AS id_ville_id_30, t0.ville_initiale_id AS ville_initiale_id_31, t0.agent_gestionnaire_id AS agent_gestionnaire_id_32 FROM programme_contenaire t0 WHERE t0.id = 5644;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.commentaire AS commentaire_3,
  t0.suivi_id AS suivi_id_4,
  t0.sous_position_id AS sous_position_id_5
FROM
  sous_suivi t0
WHERE
  t0.suivi_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.commentaire AS commentaire_3, t0.suivi_id AS suivi_id_4, t0.sous_position_id AS sous_position_id_5 FROM sous_suivi t0 WHERE t0.suivi_id = 8523;

SELECT
  *,
  c.id AS idCommande,
  (
    SELECT
      nom_ag
    FROM
      agent a
    WHERE
      a.id = c.id_cl_id
  ) AS nom_client,
  (
    SELECT
      IFNULL(
        SUM(
          ROUND(tV.prix_unit * tV.volume)
        ),
        0
      )
    FROM
      tmp_volume tV
    WHERE
      c.id = tV.commande_id
  ) AS pritotal,
  (
    SELECT
      MAX(p.id) AS maxid
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
  ) AS idFacture,
  (
    SELECT
      IFNULL(
        SUM(p.montant),
        0
      )
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
      AND p.flag_en_avance = 0
  ) AS dejaPaie,
  (
    SELECT
      IFNULL(
        SUM(p.montant),
        0
      )
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
      AND p.flag_en_avance = 1
  ) AS paieEnAvance,
  (
    SELECT
      IFNULL(
        SUM(atF.montant),
        0
      )
    FROM
      autre_frais atF
    WHERE
      atF.commande_id = c.id
  ) AS AutresFrais,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '0'
  ) AS reduction,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '1'
  ) AS compassation,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '2'
  ) AS banque,
  (
    SELECT
      r.montant
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '2'
    ORDER BY
      r.id DESC
    LIMIT
      1
  ) AS banqueDujour,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '3'
  ) AS depot
FROM
  commande c
  LEFT JOIN agent a ON (c.id_ag_id = a.id)
  LEFT JOIN programme_contenaire ctpr ON (c.id_ct_pr_id = ctpr.id)
  LEFT JOIN contenaire ct ON (ctpr.id_ct_id = ct.id)
WHERE
  c.id = 7930178
ORDER BY
  c.id DESC

SELECT *,c.id AS idCommande, 
                    (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, 
                    (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,
                    (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,
                    (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,
                    (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,
                    (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,
                    (SELECT r.montant FROM reduction r  WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ORDER BY r.id DESC LIMIT 1) AS banqueDujour,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot
                    FROM commande c LEFT JOIN  agent a ON (c.id_ag_id = a.id) LEFT JOIN  programme_contenaire ctpr ON (c.id_ct_pr_id = ctpr.id) LEFT JOIN contenaire ct ON (ctpr.id_ct_id = ct.id) WHERE c.id = 7930178 ORDER BY  c.id DESC;

SELECT
  *,
  c.id AS idCommande,
  (
    SELECT
      nom_ag
    FROM
      agent a
    WHERE
      a.id = c.id_cl_id
  ) AS nom_client,
  (
    SELECT
      IFNULL(
        SUM(
          ROUND(tV.prix_unit * tV.volume)
        ),
        0
      )
    FROM
      tmp_volume tV
    WHERE
      c.id = tV.commande_id
  ) AS pritotal,
  (
    SELECT
      MAX(p.id) AS maxid
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
  ) AS idFacture,
  (
    SELECT
      IFNULL(
        SUM(p.montant),
        0
      )
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
      AND p.flag_en_avance = 0
  ) AS dejaPaie,
  (
    SELECT
      IFNULL(
        SUM(p.montant),
        0
      )
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
      AND p.flag_en_avance = 1
  ) AS paieEnAvance,
  (
    SELECT
      IFNULL(
        SUM(atF.montant),
        0
      )
    FROM
      autre_frais atF
    WHERE
      atF.commande_id = c.id
  ) AS AutresFrais,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '0'
  ) AS reduction,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '1'
  ) AS compassation,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '2'
  ) AS banque,
  (
    SELECT
      r.montant
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '2'
    ORDER BY
      r.id DESC
    LIMIT
      1
  ) AS banqueDujour,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '3'
  ) AS depot
FROM
  commande c
  LEFT JOIN agent a ON (c.id_ag_id = a.id)
  LEFT JOIN programme_contenaire ctpr ON (c.id_ct_pr_id = ctpr.id)
  LEFT JOIN contenaire ct ON (ctpr.id_ct_id = ct.id)
WHERE
  c.id = 7924803
ORDER BY
  c.id DESC

SELECT *,c.id AS idCommande, 
                    (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, 
                    (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,
                    (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,
                    (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,
                    (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,
                    (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,
                    (SELECT r.montant FROM reduction r  WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ORDER BY r.id DESC LIMIT 1) AS banqueDujour,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot
                    FROM commande c LEFT JOIN  agent a ON (c.id_ag_id = a.id) LEFT JOIN  programme_contenaire ctpr ON (c.id_ct_pr_id = ctpr.id) LEFT JOIN contenaire ct ON (ctpr.id_ct_id = ct.id) WHERE c.id = 7924803 ORDER BY  c.id DESC;

SELECT
  *,
  c.id AS idCommande,
  (
    SELECT
      nom_ag
    FROM
      agent a
    WHERE
      a.id = c.id_cl_id
  ) AS nom_client,
  (
    SELECT
      IFNULL(
        SUM(
          ROUND(tV.prix_unit * tV.volume)
        ),
        0
      )
    FROM
      tmp_volume tV
    WHERE
      c.id = tV.commande_id
  ) AS pritotal,
  (
    SELECT
      MAX(p.id) AS maxid
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
  ) AS idFacture,
  (
    SELECT
      IFNULL(
        SUM(p.montant),
        0
      )
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
      AND p.flag_en_avance = 0
  ) AS dejaPaie,
  (
    SELECT
      IFNULL(
        SUM(p.montant),
        0
      )
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
      AND p.flag_en_avance = 1
  ) AS paieEnAvance,
  (
    SELECT
      IFNULL(
        SUM(atF.montant),
        0
      )
    FROM
      autre_frais atF
    WHERE
      atF.commande_id = c.id
  ) AS AutresFrais,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '0'
  ) AS reduction,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '1'
  ) AS compassation,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '2'
  ) AS banque,
  (
    SELECT
      r.montant
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '2'
    ORDER BY
      r.id DESC
    LIMIT
      1
  ) AS banqueDujour,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '3'
  ) AS depot
FROM
  commande c
  LEFT JOIN agent a ON (c.id_ag_id = a.id)
  LEFT JOIN programme_contenaire ctpr ON (c.id_ct_pr_id = ctpr.id)
  LEFT JOIN contenaire ct ON (ctpr.id_ct_id = ct.id)
WHERE
  c.id = 7925668
ORDER BY
  c.id DESC

SELECT *,c.id AS idCommande, 
                    (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, 
                    (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,
                    (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,
                    (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,
                    (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,
                    (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,
                    (SELECT r.montant FROM reduction r  WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ORDER BY r.id DESC LIMIT 1) AS banqueDujour,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot
                    FROM commande c LEFT JOIN  agent a ON (c.id_ag_id = a.id) LEFT JOIN  programme_contenaire ctpr ON (c.id_ct_pr_id = ctpr.id) LEFT JOIN contenaire ct ON (ctpr.id_ct_id = ct.id) WHERE c.id = 7925668 ORDER BY  c.id DESC;

SELECT
  *,
  c.id AS idCommande,
  (
    SELECT
      nom_ag
    FROM
      agent a
    WHERE
      a.id = c.id_cl_id
  ) AS nom_client,
  (
    SELECT
      IFNULL(
        SUM(
          ROUND(tV.prix_unit * tV.volume)
        ),
        0
      )
    FROM
      tmp_volume tV
    WHERE
      c.id = tV.commande_id
  ) AS pritotal,
  (
    SELECT
      MAX(p.id) AS maxid
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
  ) AS idFacture,
  (
    SELECT
      IFNULL(
        SUM(p.montant),
        0
      )
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
      AND p.flag_en_avance = 0
  ) AS dejaPaie,
  (
    SELECT
      IFNULL(
        SUM(p.montant),
        0
      )
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
      AND p.flag_en_avance = 1
  ) AS paieEnAvance,
  (
    SELECT
      IFNULL(
        SUM(atF.montant),
        0
      )
    FROM
      autre_frais atF
    WHERE
      atF.commande_id = c.id
  ) AS AutresFrais,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '0'
  ) AS reduction,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '1'
  ) AS compassation,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '2'
  ) AS banque,
  (
    SELECT
      r.montant
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '2'
    ORDER BY
      r.id DESC
    LIMIT
      1
  ) AS banqueDujour,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '3'
  ) AS depot
FROM
  commande c
  LEFT JOIN agent a ON (c.id_ag_id = a.id)
  LEFT JOIN programme_contenaire ctpr ON (c.id_ct_pr_id = ctpr.id)
  LEFT JOIN contenaire ct ON (ctpr.id_ct_id = ct.id)
WHERE
  c.id = 7925497
ORDER BY
  c.id DESC

SELECT *,c.id AS idCommande, 
                    (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, 
                    (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,
                    (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,
                    (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,
                    (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,
                    (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,
                    (SELECT r.montant FROM reduction r  WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ORDER BY r.id DESC LIMIT 1) AS banqueDujour,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot
                    FROM commande c LEFT JOIN  agent a ON (c.id_ag_id = a.id) LEFT JOIN  programme_contenaire ctpr ON (c.id_ct_pr_id = ctpr.id) LEFT JOIN contenaire ct ON (ctpr.id_ct_id = ct.id) WHERE c.id = 7925497 ORDER BY  c.id DESC;

SELECT
  *,
  c.id AS idCommande,
  (
    SELECT
      nom_ag
    FROM
      agent a
    WHERE
      a.id = c.id_cl_id
  ) AS nom_client,
  (
    SELECT
      IFNULL(
        SUM(
          ROUND(tV.prix_unit * tV.volume)
        ),
        0
      )
    FROM
      tmp_volume tV
    WHERE
      c.id = tV.commande_id
  ) AS pritotal,
  (
    SELECT
      MAX(p.id) AS maxid
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
  ) AS idFacture,
  (
    SELECT
      IFNULL(
        SUM(p.montant),
        0
      )
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
      AND p.flag_en_avance = 0
  ) AS dejaPaie,
  (
    SELECT
      IFNULL(
        SUM(p.montant),
        0
      )
    FROM
      paiement p
    WHERE
      p.id_cmd_id = c.id
      AND p.flag_en_avance = 1
  ) AS paieEnAvance,
  (
    SELECT
      IFNULL(
        SUM(atF.montant),
        0
      )
    FROM
      autre_frais atF
    WHERE
      atF.commande_id = c.id
  ) AS AutresFrais,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '0'
  ) AS reduction,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '1'
  ) AS compassation,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '2'
  ) AS banque,
  (
    SELECT
      r.montant
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '2'
    ORDER BY
      r.id DESC
    LIMIT
      1
  ) AS banqueDujour,
  (
    SELECT
      IFNULL(
        SUM(r.montant),
        0
      )
    FROM
      reduction r
    WHERE
      r.id_cmd_id = c.id
      AND r.flag_compassation = '3'
  ) AS depot
FROM
  commande c
  LEFT JOIN agent a ON (c.id_ag_id = a.id)
  LEFT JOIN programme_contenaire ctpr ON (c.id_ct_pr_id = ctpr.id)
  LEFT JOIN contenaire ct ON (ctpr.id_ct_id = ct.id)
WHERE
  c.id = 7925393
ORDER BY
  c.id DESC

SELECT *,c.id AS idCommande, 
                    (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, 
                    (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,
                    (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,
                    (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,
                    (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,
                    (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,
                    (SELECT r.montant FROM reduction r  WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ORDER BY r.id DESC LIMIT 1) AS banqueDujour,
                    (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot
                    FROM commande c LEFT JOIN  agent a ON (c.id_ag_id = a.id) LEFT JOIN  programme_contenaire ctpr ON (c.id_ct_pr_id = ctpr.id) LEFT JOIN contenaire ct ON (ctpr.id_ct_id = ct.id) WHERE c.id = 7925393 ORDER BY  c.id DESC;