Symfony Profiler

[
  "route" => "agent_commandes"
  "route_parameters" => [
    "_route" => "agent_commandes"
    "_controller" => "App\Controller\flutterapi\CommandeController::getCommandes"
  ]
  "request_uri" => "https://jpcpartageons.afisarl.com/commandes"
  "method" => "POST"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "localhost"
    "port" => 3306
    "user" => "u110001631_afi"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "u110001631_afi"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "243854861697"
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "sql" => """
    \n
                        SELECT *,c.id As idCommande, \n
                        (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, \n
                        (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,\n
                        (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,\n
                        (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,\n
                        (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,\n
                        (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,\n
                        (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,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot\n
                        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 = 7929861 ORDER BY  c.id DESC
    """
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5703
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5703
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8532
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 292
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8842
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7929861
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7929861
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7929861
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7929861
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7929861
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_contenaire AS nom_contenaire_2 FROM contenaire t0 WHERE t0.id = ?"
  "params" => [
    1 => 5852
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7929861
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                        SELECT *,c.id As idCommande, \n
                        (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, \n
                        (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,\n
                        (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,\n
                        (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,\n
                        (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,\n
                        (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,\n
                        (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,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot\n
                        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 = 7929890 ORDER BY  c.id DESC
    """
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5705
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5705
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8535
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7929890
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7929890
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7929890
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7929890
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_contenaire AS nom_contenaire_2 FROM contenaire t0 WHERE t0.id = ?"
  "params" => [
    1 => 5854
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7929890
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7929890
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                        SELECT *,c.id As idCommande, \n
                        (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, \n
                        (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,\n
                        (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,\n
                        (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,\n
                        (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,\n
                        (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,\n
                        (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,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot\n
                        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 = 7923270 ORDER BY  c.id DESC
    """
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5310
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5310
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8501
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 268
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8472
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7630
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 283
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8539
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 294
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7923270
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7923270
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7923270
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7923270
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                        SELECT *,c.id As idCommande, \n
                        (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, \n
                        (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,\n
                        (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,\n
                        (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,\n
                        (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,\n
                        (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,\n
                        (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,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot\n
                        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 = 7922963 ORDER BY  c.id DESC
    """
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_contenaire AS nom_contenaire_2 FROM contenaire t0 WHERE t0.id = ?"
  "params" => [
    1 => 5446
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7923270
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7923270
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8381
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7671
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5336
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5336
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7922963
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7922963
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7922963
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7922963
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8486
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 263
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                        SELECT *,c.id As idCommande, \n
                        (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, \n
                        (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,\n
                        (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,\n
                        (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,\n
                        (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,\n
                        (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,\n
                        (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,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot\n
                        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 = 7921377 ORDER BY  c.id DESC
    """
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_contenaire AS nom_contenaire_2 FROM contenaire t0 WHERE t0.id = ?"
  "params" => [
    1 => 5473
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7922963
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7922963
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5174
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5174
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7921377
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7921377
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7921377
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7921377
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7535
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7921377
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7921377
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_contenaire AS nom_contenaire_2 FROM contenaire t0 WHERE t0.id = ?"
  "params" => [
    1 => 5302
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                        SELECT *,c.id As idCommande, \n
                        (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, \n
                        (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,\n
                        (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,\n
                        (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,\n
                        (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,\n
                        (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,\n
                        (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,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot\n
                        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 = 7920433 ORDER BY  c.id DESC
    """
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5182
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 264
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5182
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7415
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7697
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7789
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7955
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 296
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7992
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 290
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7920433
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7920433
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7920433
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7920433
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7920433
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7920433
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_contenaire AS nom_contenaire_2 FROM contenaire t0 WHERE t0.id = ?"
  "params" => [
    1 => 5311
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                        SELECT *,c.id As idCommande, \n
                        (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, \n
                        (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,\n
                        (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,\n
                        (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,\n
                        (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,\n
                        (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,\n
                        (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,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot\n
                        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 = 7919889 ORDER BY  c.id DESC
    """
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5089
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5089
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7919889
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7919889
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7919889
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7919889
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => """
    \n
                        SELECT *,c.id As idCommande, \n
                        (SELECT nom_ag FROM agent a WHERE a.id = c.id_cl_id ) AS nom_client, \n
                        (SELECT IFNULL(SUM(ROUND(tV.prix_unit * tV.volume)),0) FROM tmp_volume tV WHERE c.id = tV.commande_id ) AS pritotal,\n
                        (SELECT MAX(p.id) AS maxid FROM paiement p WHERE p.id_cmd_id = c.id ) AS idFacture,\n
                        (SELECT IFNULL(SUM(p.montant),0) FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 0 ) AS dejaPaie,\n
                        (SELECT IFNULL(SUM(p.montant),0)  FROM paiement p WHERE p.id_cmd_id = c.id AND p.flag_en_avance = 1 ) AS paieEnAvance,\n
                        (SELECT IFNULL(SUM(atF.montant),0) FROM autre_frais atF WHERE atF.commande_id = c.id ) AS AutresFrais,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '0') AS reduction,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '1' ) AS compassation,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '2' ) AS banque,\n
                        (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,\n
                        (SELECT IFNULL(SUM(r.montant),0) FROM reduction r WHERE r.id_cmd_id = c.id AND r.flag_compassation = '3' ) AS depot\n
                        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 = 7917914 ORDER BY  c.id DESC
    """
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_contenaire AS nom_contenaire_2 FROM contenaire t0 WHERE t0.id = ?"
  "params" => [
    1 => 5218
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7919889
  ]
  "types" => [
    1 => 1
  ]
]