Symfony Profiler

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 = '243851110861' AND p1_.validation = 1 ORDER BY c0_.date_commande DESC LIMIT 100;

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 = 7928269
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 = 7928269 ORDER BY  c.id DESC;

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 = 5478;

SELECT
  t0.id AS id_1,
  t0.lieu AS lieu_2,
  t0.id_position AS id_position_3,
  t0.date_operation AS date_operation_4,
  t0.position_actuelle_flag AS position_actuelle_flag_5,
  t0.id_ct_pr_id AS id_ct_pr_id_6
FROM
  suivi_contenaire t0
WHERE
  t0.id_ct_pr_id = ?

SELECT t0.id AS id_1, t0.lieu AS lieu_2, t0.id_position AS id_position_3, t0.date_operation AS date_operation_4, t0.position_actuelle_flag AS position_actuelle_flag_5, t0.id_ct_pr_id AS id_ct_pr_id_6 FROM suivi_contenaire t0 WHERE t0.id_ct_pr_id = 5478;

SELECT
  t0.id AS id_1,
  t0.quantite AS quantite_2,
  t0.sortie_at AS sortie_at_3,
  t0.remarque AS remarque_4,
  t0.noms AS noms_5,
  t0.telephone AS telephone_6,
  t0.plaque AS plaque_7,
  t0.commande_id AS commande_id_8,
  t0.user_id AS user_id_9
FROM
  depot t0
WHERE
  t0.commande_id = ?

SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.sortie_at AS sortie_at_3, t0.remarque AS remarque_4, t0.noms AS noms_5, t0.telephone AS telephone_6, t0.plaque AS plaque_7, t0.commande_id AS commande_id_8, t0.user_id AS user_id_9 FROM depot t0 WHERE t0.commande_id = 7928269;

SELECT
  t0.id AS id_1,
  t0.nom_ag AS nom_ag_2,
  t0.contact_ag AS contact_ag_3,
  t0.image_ag AS image_ag_4,
  t0.token_flutter AS token_flutter_5,
  t0.contact_whatsapp AS contact_whatsapp_6,
  t0.sexe AS sexe_7,
  t0.type_client_agent AS type_client_agent_8,
  t0.contact_ag1 AS contact_ag1_9,
  t0.code AS code_10,
  t0.prefixcode AS prefixcode_11,
  t0.langue AS langue_12,
  t0.mco AS mco_13,
  t0.cargo_agent AS cargo_agent_14,
  t0.ancien AS ancien_15,
  t0.is_verifier AS is_verifier_16,
  t0.codeverification AS codeverification_17,
  t0.clientblocker AS clientblocker_18,
  t0.admin AS admin_19,
  t0.face_signature AS face_signature_20,
  t0.daily_rate AS daily_rate_21,
  t0.ville_id AS ville_id_22,
  t23.id AS id_24,
  t23.etat AS etat_25,
  t23.role AS role_26,
  t23.date_created AS date_created_27,
  t23.date_connected AS date_connected_28,
  t23.status AS status_29,
  t23.user_name AS user_name_30,
  t23.password AS password_31,
  t23.langue AS langue_32,
  t23.flag_sms AS flag_sms_33,
  t23.flag_voice_sms AS flag_voice_sms_34,
  t23.flag_voice_whatsapp AS flag_voice_whatsapp_35,
  t23.is_mco AS is_mco_36,
  t23.i_sflag_calacul AS i_sflag_calacul_37,
  t23.caisse_localite AS caisse_localite_38,
  t23.ville_id AS ville_id_39,
  t23.id_ag_id AS id_ag_id_40
FROM
  agent t0
  LEFT JOIN utilisateur t23 ON t23.id_ag_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_ag AS nom_ag_2, t0.contact_ag AS contact_ag_3, t0.image_ag AS image_ag_4, t0.token_flutter AS token_flutter_5, t0.contact_whatsapp AS contact_whatsapp_6, t0.sexe AS sexe_7, t0.type_client_agent AS type_client_agent_8, t0.contact_ag1 AS contact_ag1_9, t0.code AS code_10, t0.prefixcode AS prefixcode_11, t0.langue AS langue_12, t0.mco AS mco_13, t0.cargo_agent AS cargo_agent_14, t0.ancien AS ancien_15, t0.is_verifier AS is_verifier_16, t0.codeverification AS codeverification_17, t0.clientblocker AS clientblocker_18, t0.admin AS admin_19, t0.face_signature AS face_signature_20, t0.daily_rate AS daily_rate_21, t0.ville_id AS ville_id_22, t23.id AS id_24, t23.etat AS etat_25, t23.role AS role_26, t23.date_created AS date_created_27, t23.date_connected AS date_connected_28, t23.status AS status_29, t23.user_name AS user_name_30, t23.password AS password_31, t23.langue AS langue_32, t23.flag_sms AS flag_sms_33, t23.flag_voice_sms AS flag_voice_sms_34, t23.flag_voice_whatsapp AS flag_voice_whatsapp_35, t23.is_mco AS is_mco_36, t23.i_sflag_calacul AS i_sflag_calacul_37, t23.caisse_localite AS caisse_localite_38, t23.ville_id AS ville_id_39, t23.id_ag_id AS id_ag_id_40 FROM agent t0 LEFT JOIN utilisateur t23 ON t23.id_ag_id = t0.id WHERE t0.id = 8773;

SELECT
  t0.id AS id_1,
  t0.volume AS volume_2,
  t0.prix_unit AS prix_unit_3,
  t0.unite AS unite_4,
  t0.modification AS modification_5,
  t0.commande_id AS commande_id_6
FROM
  tmp_volume t0
WHERE
  t0.commande_id = ?

SELECT t0.id AS id_1, t0.volume AS volume_2, t0.prix_unit AS prix_unit_3, t0.unite AS unite_4, t0.modification AS modification_5, t0.commande_id AS commande_id_6 FROM tmp_volume t0 WHERE t0.commande_id = 7928269;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.montant AS montant_3,
  t0.modification AS modification_4,
  t0.commande_id AS commande_id_5
FROM
  autre_frais t0
WHERE
  t0.commande_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.montant AS montant_3, t0.modification AS modification_4, t0.commande_id AS commande_id_5 FROM autre_frais t0 WHERE t0.commande_id = 7928269;

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 = 7928269;

SELECT
  t0.id AS id_1,
  t0.montant AS montant_2,
  t0.date_operation AS date_operation_3,
  t0.flag_en_avance AS flag_en_avance_4,
  t0.id_cmd_id AS id_cmd_id_5,
  t0.id_ag_id AS id_ag_id_6
FROM
  paiement 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.flag_en_avance AS flag_en_avance_4, t0.id_cmd_id AS id_cmd_id_5, t0.id_ag_id AS id_ag_id_6 FROM paiement t0 WHERE t0.id_cmd_id = 7928269;

SELECT
  t0.id AS id_1,
  t0.qte AS qte_2,
  t0.libelle AS libelle_3,
  t0.modification AS modification_4,
  t0.commande_id AS commande_id_5
FROM
  tmp_marchandise t0
WHERE
  t0.commande_id = ?

SELECT t0.id AS id_1, t0.qte AS qte_2, t0.libelle AS libelle_3, t0.modification AS modification_4, t0.commande_id AS commande_id_5 FROM tmp_marchandise t0 WHERE t0.commande_id = 7928269;

SELECT
  t0.id AS id_1,
  t0.nom_contenaire AS nom_contenaire_2
FROM
  contenaire t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_contenaire AS nom_contenaire_2 FROM contenaire t0 WHERE t0.id = 5620;

SELECT
  t0.id AS id_1,
  t0.nomville AS nomville_2,
  t0.adresse1 AS adresse1_3,
  t0.adresse2 AS adresse2_4,
  t0.email AS email_5,
  t0.num_tel AS num_tel_6,
  t0.addresse3 AS addresse3_7,
  t0.addresse4 AS addresse4_8,
  t0.addresse5 AS addresse5_9,
  t0.addresse6 AS addresse6_10,
  t0.flag_ville AS flag_ville_11,
  t0.logo AS logo_12,
  t0.port_bateau AS port_bateau_13,
  t0.taux_du_jour_pays AS taux_du_jour_pays_14,
  t0.is_taux AS is_taux_15,
  t0.monnaie AS monnaie_16,
  t0.tokenurl AS tokenurl_17,
  t0.token_id AS token_id_18,
  t0.basdepage AS basdepage_19,
  t0.basdepagemco AS basdepagemco_20,
  t0.cbm AS cbm_21,
  t0.tonne AS tonne_22,
  t0.kg AS kg_23,
  t0.conteneur AS conteneur_24,
  t0.kgelec AS kgelec_25,
  t0.prefixe_code AS prefixe_code_26,
  t0.estimateddate_text_air_cargo AS estimateddate_text_air_cargo_27,
  t0.estimateddate_text_sea_cargo AS estimateddate_text_sea_cargo_28
FROM
  ville t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nomville AS nomville_2, t0.adresse1 AS adresse1_3, t0.adresse2 AS adresse2_4, t0.email AS email_5, t0.num_tel AS num_tel_6, t0.addresse3 AS addresse3_7, t0.addresse4 AS addresse4_8, t0.addresse5 AS addresse5_9, t0.addresse6 AS addresse6_10, t0.flag_ville AS flag_ville_11, t0.logo AS logo_12, t0.port_bateau AS port_bateau_13, t0.taux_du_jour_pays AS taux_du_jour_pays_14, t0.is_taux AS is_taux_15, t0.monnaie AS monnaie_16, t0.tokenurl AS tokenurl_17, t0.token_id AS token_id_18, t0.basdepage AS basdepage_19, t0.basdepagemco AS basdepagemco_20, t0.cbm AS cbm_21, t0.tonne AS tonne_22, t0.kg AS kg_23, t0.conteneur AS conteneur_24, t0.kgelec AS kgelec_25, t0.prefixe_code AS prefixe_code_26, t0.estimateddate_text_air_cargo AS estimateddate_text_air_cargo_27, t0.estimateddate_text_sea_cargo AS estimateddate_text_sea_cargo_28 FROM ville t0 WHERE t0.id = 14;

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 = 7923198
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 = 7923198 ORDER BY  c.id DESC;

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 = 5341;

SELECT
  t0.id AS id_1,
  t0.lieu AS lieu_2,
  t0.id_position AS id_position_3,
  t0.date_operation AS date_operation_4,
  t0.position_actuelle_flag AS position_actuelle_flag_5,
  t0.id_ct_pr_id AS id_ct_pr_id_6
FROM
  suivi_contenaire t0
WHERE
  t0.id_ct_pr_id = ?

SELECT t0.id AS id_1, t0.lieu AS lieu_2, t0.id_position AS id_position_3, t0.date_operation AS date_operation_4, t0.position_actuelle_flag AS position_actuelle_flag_5, t0.id_ct_pr_id AS id_ct_pr_id_6 FROM suivi_contenaire t0 WHERE t0.id_ct_pr_id = 5341;

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 = 7678;

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 = 8045;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.message_client AS message_client_3,
  t0.niveau AS niveau_4,
  t0.track_position_id AS track_position_id_5
FROM
  sous_position t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.message_client AS message_client_3, t0.niveau AS niveau_4, t0.track_position_id AS track_position_id_5 FROM sous_position t0 WHERE t0.id = 293;

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 = 8140;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.message_client AS message_client_3,
  t0.niveau AS niveau_4,
  t0.track_position_id AS track_position_id_5
FROM
  sous_position t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.message_client AS message_client_3, t0.niveau AS niveau_4, t0.track_position_id AS track_position_id_5 FROM sous_position t0 WHERE t0.id = 263;

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 = 8257;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.message_client AS message_client_3,
  t0.niveau AS niveau_4,
  t0.track_position_id AS track_position_id_5
FROM
  sous_position t0
WHERE
  t0.id = ?