Symfony Profiler

[
  "route" => "app_logescom_vente_facturation_validation"
  "route_parameters" => [
    "_route" => "app_logescom_vente_facturation_validation"
    "_controller" => "App\Controller\Logescom\Vente\FacturationController::validation"
    "lieu_vente" => "1"
  ]
  "request_uri" => "https://etselboubacarbalde.damkocompany.com/public/logescom/vente/facturation/valdation/1"
  "method" => "POST"
]

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

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\UserAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "App\Security\UserAuthenticator"
]

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

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

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "u553146816_elhboubabalabe"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "u553146816_elhboubabalabe"
    "serverVersion" => "5.7.26"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.email AS email_8, t0.type_user AS type_user_9, t0.date_creation AS date_creation_10, t0.adresse AS adresse_11, t0.ville AS ville_12, t0.pays AS pays_13, t0.statut AS statut_14, t0.reference AS reference_15, t0.lieu_vente_id AS lieu_vente_id_16, t0.region_id AS region_id_17 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "MtBalde"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

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

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

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

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

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

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

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

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

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

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

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "ContainerXQp3ZVO\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_devise AS nom_devise_2 FROM devise t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.pays AS pays_3, t0.region AS region_4, t0.ville AS ville_5, t0.telephone AS telephone_6, t0.email AS email_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.initial AS initial_10, t0.type_commerce AS type_commerce_11, t0.lieu AS lieu_12, t0.entreprise_id AS entreprise_id_13, t0.gestionnaire_id AS gestionnaire_id_14 FROM lieux_ventes t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT MAX(f0_.id) AS sclr_0 FROM facturation f0_"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_stock AS nom_stock_2, t0.adresse AS adresse_3, t0.surface AS surface_4, t0.nbre_pieces AS nbre_pieces_5, t0.type AS type_6, t0.statut AS statut_7, t0.lieu_vente_id AS lieu_vente_id_8, t0.responsable_id AS responsable_id_9 FROM liste_stock t0 WHERE t0.id = ?"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2, t0.type AS type_3, t0.numero_compte AS numero_compte_4, t0.document AS document_5, t0.point_de_vente_id AS point_de_vente_id_6 FROM caisse t0 WHERE t0.id = ?"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.designation AS designation_2 FROM mode_paiement t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_devise AS nom_devise_2 FROM devise t0 WHERE t0.nom_devise = ? LIMIT 1"
  "params" => [
    1 => "gnf"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_operation AS nom_operation_2 FROM categorie_operation t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.numero_compte AS numero_compte_2, t0.commentaire AS commentaire_3 FROM compte_operation t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_devise AS nom_devise_2 FROM devise t0 WHERE t0.nom_devise = ? LIMIT 1"
  "params" => [
    1 => "eu"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_devise AS nom_devise_2 FROM devise t0 WHERE t0.nom_devise = ? LIMIT 1"
  "params" => [
    1 => "us"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom_devise AS nom_devise_2 FROM devise t0 WHERE t0.nom_devise = ? LIMIT 1"
  "params" => [
    1 => "cfa"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix_vente AS prix_vente_4, t0.code_barre AS code_barre_5, t0.nbre_piece AS nbre_piece_6, t0.nbre_paquet AS nbre_paquet_7, t0.type_produit AS type_produit_8, t0.nbre_vente AS nbre_vente_9, t0.statut AS statut_10, t0.statut_comptable AS statut_comptable_11, t0.tva AS tva_12, t0.categorie_id AS categorie_id_13, t0.epaisseur_id AS epaisseur_id_14, t0.dimension_id AS dimension_id_15, t0.origine_id AS origine_id_16, t0.type_id AS type_id_17 FROM products t0 WHERE t0.id = ?"
  "params" => [
    1 => 91
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 91
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix_vente AS prix_vente_4, t0.code_barre AS code_barre_5, t0.nbre_piece AS nbre_piece_6, t0.nbre_paquet AS nbre_paquet_7, t0.type_produit AS type_produit_8, t0.nbre_vente AS nbre_vente_9, t0.statut AS statut_10, t0.statut_comptable AS statut_comptable_11, t0.tva AS tva_12, t0.categorie_id AS categorie_id_13, t0.epaisseur_id AS epaisseur_id_14, t0.dimension_id AS dimension_id_15, t0.origine_id AS origine_id_16, t0.type_id AS type_id_17 FROM products t0 WHERE t0.id = ?"
  "params" => [
    1 => 141
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 141
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix_vente AS prix_vente_4, t0.code_barre AS code_barre_5, t0.nbre_piece AS nbre_piece_6, t0.nbre_paquet AS nbre_paquet_7, t0.type_produit AS type_produit_8, t0.nbre_vente AS nbre_vente_9, t0.statut AS statut_10, t0.statut_comptable AS statut_comptable_11, t0.tva AS tva_12, t0.categorie_id AS categorie_id_13, t0.epaisseur_id AS epaisseur_id_14, t0.dimension_id AS dimension_id_15, t0.origine_id AS origine_id_16, t0.type_id AS type_id_17 FROM products t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix_vente AS prix_vente_4, t0.code_barre AS code_barre_5, t0.nbre_piece AS nbre_piece_6, t0.nbre_paquet AS nbre_paquet_7, t0.type_produit AS type_produit_8, t0.nbre_vente AS nbre_vente_9, t0.statut AS statut_10, t0.statut_comptable AS statut_comptable_11, t0.tva AS tva_12, t0.categorie_id AS categorie_id_13, t0.epaisseur_id AS epaisseur_id_14, t0.dimension_id AS dimension_id_15, t0.origine_id AS origine_id_16, t0.type_id AS type_id_17 FROM products t0 WHERE t0.id = ?"
  "params" => [
    1 => 515
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 515
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix_vente AS prix_vente_4, t0.code_barre AS code_barre_5, t0.nbre_piece AS nbre_piece_6, t0.nbre_paquet AS nbre_paquet_7, t0.type_produit AS type_produit_8, t0.nbre_vente AS nbre_vente_9, t0.statut AS statut_10, t0.statut_comptable AS statut_comptable_11, t0.tva AS tva_12, t0.categorie_id AS categorie_id_13, t0.epaisseur_id AS epaisseur_id_14, t0.dimension_id AS dimension_id_15, t0.origine_id AS origine_id_16, t0.type_id AS type_id_17 FROM products t0 WHERE t0.id = ?"
  "params" => [
    1 => 167
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 167
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix_vente AS prix_vente_4, t0.code_barre AS code_barre_5, t0.nbre_piece AS nbre_piece_6, t0.nbre_paquet AS nbre_paquet_7, t0.type_produit AS type_produit_8, t0.nbre_vente AS nbre_vente_9, t0.statut AS statut_10, t0.statut_comptable AS statut_comptable_11, t0.tva AS tva_12, t0.categorie_id AS categorie_id_13, t0.epaisseur_id AS epaisseur_id_14, t0.dimension_id AS dimension_id_15, t0.origine_id AS origine_id_16, t0.type_id AS type_id_17 FROM products t0 WHERE t0.id = ?"
  "params" => [
    1 => 240
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 240
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix_vente AS prix_vente_4, t0.code_barre AS code_barre_5, t0.nbre_piece AS nbre_piece_6, t0.nbre_paquet AS nbre_paquet_7, t0.type_produit AS type_produit_8, t0.nbre_vente AS nbre_vente_9, t0.statut AS statut_10, t0.statut_comptable AS statut_comptable_11, t0.tva AS tva_12, t0.categorie_id AS categorie_id_13, t0.epaisseur_id AS epaisseur_id_14, t0.dimension_id AS dimension_id_15, t0.origine_id AS origine_id_16, t0.type_id AS type_id_17 FROM products t0 WHERE t0.id = ?"
  "params" => [
    1 => 123
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 123
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 91
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.product_id = ? AND t0.stock_produit_id = ? LIMIT 1"
  "params" => [
    1 => 91
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.stock_produit_id = ? AND t0.product_id = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 91
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 141
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.product_id = ? AND t0.stock_produit_id = ? LIMIT 1"
  "params" => [
    1 => 141
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.stock_produit_id = ? AND t0.product_id = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 141
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.type AS type_2, t0.produit1_id AS produit1_id_3, t0.produit2_id AS produit2_id_4 FROM liaison_produit t0 WHERE t0.produit2_id = ? LIMIT 1"
  "params" => [
    1 => 141
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.product_id = ? AND t0.stock_produit_id = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.stock_produit_id = ? AND t0.product_id = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT s0_.prix_achat AS prix_achat_0, s0_.prix_revient AS prix_revient_1 FROM stock s0_ LEFT JOIN liste_stock l1_ ON s0_.stock_produit_id = l1_.id WHERE s0_.product_id = ? AND (s0_.prix_achat > 0 OR s0_.prix_revient > 0) AND l1_.lieu_vente_id = ? ORDER BY s0_.id DESC LIMIT 1"
  "params" => [
    1 => 515
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 515
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.product_id = ? AND t0.stock_produit_id = ? LIMIT 1"
  "params" => [
    1 => 515
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.stock_produit_id = ? AND t0.product_id = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 515
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 167
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.product_id = ? AND t0.stock_produit_id = ? LIMIT 1"
  "params" => [
    1 => 167
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.stock_produit_id = ? AND t0.product_id = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 167
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 240
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.product_id = ? AND t0.stock_produit_id = ? LIMIT 1"
  "params" => [
    1 => 240
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.stock_produit_id = ? AND t0.product_id = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 240
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.quantite_min AS quantite_min_1, p0_.quantite_bonus AS quantite_bonus_2, p0_.etat AS etat_3, p0_.date_saisie AS date_saisie_4, p0_.produit_bonus_id AS produit_bonus_id_5, p0_.lieu_vente_id AS lieu_vente_id_6, p0_.saisie_par_id AS saisie_par_id_7 FROM promotion p0_ INNER JOIN promotion_products p2_ ON p0_.id = p2_.promotion_id INNER JOIN products p1_ ON p1_.id = p2_.products_id WHERE p1_.id = ?"
  "params" => [
    1 => 123
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.product_id = ? AND t0.stock_produit_id = ? LIMIT 1"
  "params" => [
    1 => 123
    2 => 1
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.stock_produit_id = ? AND t0.product_id = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 123
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "INSERT INTO facturation (numero_facture, total_facture, montant_paye, montant_remise, etat, etat_livraison, date_facturation, date_saisie, date_alerte, commentaire, nom_client_cash, frais_sup, taux, client_id, caisse_id, lieu_vente_id, saisie_par_id, mode_paie_id, proformat_id, devise_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "acf260605"
    2 => "1195000"
    3 => "1195000"
    4 => "0"
    5 => "payé"
    6 => "livré"
    7 => "2026-04-15 11:48:32"
    8 => "2026-04-15 11:48:32"
    9 => null
    10 => null
    11 => null
    12 => "0"
    13 => null
    14 => null
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => null
    20 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
  ]
]

[
  "sql" => "INSERT INTO mouvement_caisse (type_mouvement, montant, date_operation, date_saisie, numero_paie, banque_cheque, taux, etat_operation, date_sortie, type_sortie, detail_sortie, lieu_vente_id, caisse_id, categorie_operation_id, compte_operation_id, devise_id, decaissement_id, avance_salaire_id, paiement_salaire_id, depense_id, versement_id, transfert_fond_id, cheque_espece_id, recette_id, facturation_id, mode_paie_id, retour_product_id, echange_id, saisie_par_id, cloture_id, sortie_stock_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "facturation"
    2 => "1195000"
    3 => "2026-04-15 11:48:32"
    4 => "2026-04-15 11:48:32"
    5 => null
    6 => null
    7 => 1.0
    8 => "non traite"
    9 => null
    10 => null
    11 => null
    12 => 1
    13 => 1
    14 => 1
    15 => 6
    16 => 1
    17 => null
    18 => null
    19 => null
    20 => null
    21 => null
    22 => null
    23 => null
    24 => null
    25 => 605
    26 => 1
    27 => null
    28 => null
    29 => 1
    30 => null
    31 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
    17 => 1
    18 => 1
    19 => 1
    20 => 1
    21 => 1
    22 => 1
    23 => 1
    24 => 1
    25 => 1
    26 => 1
    27 => 1
    28 => 1
    29 => 1
    30 => 1
    31 => 1
  ]
]

[
  "sql" => "INSERT INTO commande_product (prix_vente, prix_revient, prix_achat, quantite, quantite_livre, remise, tva, facturation_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "160000"
    2 => "132000.00"
    3 => "148000.00"
    4 => 1.0
    5 => 1.0
    6 => "0"
    7 => 0.0
    8 => 605
    9 => 91
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 1
    9 => 1
  ]
]

[
  "sql" => "INSERT INTO livraison (quantite_liv, date_livraison, date_saisie, commentaire, commande_id, saisie_par_id, stock_id) VALUES (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1.0
    2 => "2026-04-15 11:48:32"
    3 => "2026-04-15 11:48:32"
    4 => "livraison direct"
    5 => 7205
    6 => 1
    7 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "INSERT INTO mouvement_product (quantite, date_operation, origine, description, stock_product_id, product_id, lieu_vente_id, personnel_id, client_id, inventaire_id, anomalie_id, transfert_id, achat_fournisseur_id, livraison_id, livraison_multiple_id, sortie_stock_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => -1.0
    2 => "2026-04-15 11:48:32"
    3 => "vente direct"
    4 => "vente direct"
    5 => 1
    6 => 91
    7 => 1
    8 => 1
    9 => null
    10 => null
    11 => null
    12 => null
    13 => null
    14 => 6948
    15 => null
    16 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
  ]
]

[
  "sql" => "INSERT INTO commande_product (prix_vente, prix_revient, prix_achat, quantite, quantite_livre, remise, tva, facturation_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "329000"
    2 => "300000.00"
    3 => "290000.00"
    4 => 2.0
    5 => 2.0
    6 => "0"
    7 => 0.0
    8 => 605
    9 => 141
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 1
    9 => 1
  ]
]

[
  "sql" => "INSERT INTO livraison (quantite_liv, date_livraison, date_saisie, commentaire, commande_id, saisie_par_id, stock_id) VALUES (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 2.0
    2 => "2026-04-15 11:48:32"
    3 => "2026-04-15 11:48:32"
    4 => "livraison direct"
    5 => 7206
    6 => 1
    7 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "INSERT INTO mouvement_product (quantite, date_operation, origine, description, stock_product_id, product_id, lieu_vente_id, personnel_id, client_id, inventaire_id, anomalie_id, transfert_id, achat_fournisseur_id, livraison_id, livraison_multiple_id, sortie_stock_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => -2.0
    2 => "2026-04-15 11:48:32"
    3 => "vente direct"
    4 => "vente direct"
    5 => 1
    6 => 141
    7 => 1
    8 => 1
    9 => null
    10 => null
    11 => null
    12 => null
    13 => null
    14 => 6949
    15 => null
    16 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
  ]
]

[
  "sql" => "INSERT INTO commande_product (prix_vente, prix_revient, prix_achat, quantite, quantite_livre, remise, tva, facturation_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "20000"
    2 => "15000.00"
    3 => "17100.00"
    4 => 1.0
    5 => 1.0
    6 => "0"
    7 => 0.0
    8 => 605
    9 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 1
    9 => 1
  ]
]

[
  "sql" => "INSERT INTO livraison (quantite_liv, date_livraison, date_saisie, commentaire, commande_id, saisie_par_id, stock_id) VALUES (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1.0
    2 => "2026-04-15 11:48:32"
    3 => "2026-04-15 11:48:32"
    4 => "livraison direct"
    5 => 7207
    6 => 1
    7 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "INSERT INTO mouvement_product (quantite, date_operation, origine, description, stock_product_id, product_id, lieu_vente_id, personnel_id, client_id, inventaire_id, anomalie_id, transfert_id, achat_fournisseur_id, livraison_id, livraison_multiple_id, sortie_stock_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => -1.0
    2 => "2026-04-15 11:48:32"
    3 => "vente direct"
    4 => "vente direct"
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => null
    10 => null
    11 => null
    12 => null
    13 => null
    14 => 6950
    15 => null
    16 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
  ]
]

[
  "sql" => "INSERT INTO commande_product (prix_vente, prix_revient, prix_achat, quantite, quantite_livre, remise, tva, facturation_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "10000"
    2 => "0.00"
    3 => "5000.00"
    4 => 1.0
    5 => 1.0
    6 => "0"
    7 => 0.0
    8 => 605
    9 => 515
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 1
    9 => 1
  ]
]

[
  "sql" => "INSERT INTO livraison (quantite_liv, date_livraison, date_saisie, commentaire, commande_id, saisie_par_id, stock_id) VALUES (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1.0
    2 => "2026-04-15 11:48:32"
    3 => "2026-04-15 11:48:32"
    4 => "livraison direct"
    5 => 7208
    6 => 1
    7 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "INSERT INTO mouvement_product (quantite, date_operation, origine, description, stock_product_id, product_id, lieu_vente_id, personnel_id, client_id, inventaire_id, anomalie_id, transfert_id, achat_fournisseur_id, livraison_id, livraison_multiple_id, sortie_stock_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => -1.0
    2 => "2026-04-15 11:48:32"
    3 => "vente direct"
    4 => "vente direct"
    5 => 1
    6 => 515
    7 => 1
    8 => 1
    9 => null
    10 => null
    11 => null
    12 => null
    13 => null
    14 => 6951
    15 => null
    16 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
  ]
]

[
  "sql" => "INSERT INTO commande_product (prix_vente, prix_revient, prix_achat, quantite, quantite_livre, remise, tva, facturation_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "150000"
    2 => "115000.00"
    3 => "131400.00"
    4 => 1.0
    5 => 1.0
    6 => "0"
    7 => 0.0
    8 => 605
    9 => 167
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 1
    9 => 1
  ]
]

[
  "sql" => "INSERT INTO livraison (quantite_liv, date_livraison, date_saisie, commentaire, commande_id, saisie_par_id, stock_id) VALUES (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1.0
    2 => "2026-04-15 11:48:32"
    3 => "2026-04-15 11:48:32"
    4 => "livraison direct"
    5 => 7209
    6 => 1
    7 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "INSERT INTO mouvement_product (quantite, date_operation, origine, description, stock_product_id, product_id, lieu_vente_id, personnel_id, client_id, inventaire_id, anomalie_id, transfert_id, achat_fournisseur_id, livraison_id, livraison_multiple_id, sortie_stock_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => -1.0
    2 => "2026-04-15 11:48:32"
    3 => "vente direct"
    4 => "vente direct"
    5 => 1
    6 => 167
    7 => 1
    8 => 1
    9 => null
    10 => null
    11 => null
    12 => null
    13 => null
    14 => 6952
    15 => null
    16 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
  ]
]

[
  "sql" => "INSERT INTO commande_product (prix_vente, prix_revient, prix_achat, quantite, quantite_livre, remise, tva, facturation_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "60000"
    2 => "55000.00"
    3 => "57600.00"
    4 => 1.0
    5 => 1.0
    6 => "0"
    7 => 0.0
    8 => 605
    9 => 240
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 1
    9 => 1
  ]
]

[
  "sql" => "INSERT INTO livraison (quantite_liv, date_livraison, date_saisie, commentaire, commande_id, saisie_par_id, stock_id) VALUES (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1.0
    2 => "2026-04-15 11:48:32"
    3 => "2026-04-15 11:48:32"
    4 => "livraison direct"
    5 => 7210
    6 => 1
    7 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "INSERT INTO mouvement_product (quantite, date_operation, origine, description, stock_product_id, product_id, lieu_vente_id, personnel_id, client_id, inventaire_id, anomalie_id, transfert_id, achat_fournisseur_id, livraison_id, livraison_multiple_id, sortie_stock_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => -1.0
    2 => "2026-04-15 11:48:32"
    3 => "vente direct"
    4 => "vente direct"
    5 => 1
    6 => 240
    7 => 1
    8 => 1
    9 => null
    10 => null
    11 => null
    12 => null
    13 => null
    14 => 6953
    15 => null
    16 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
  ]
]

[
  "sql" => "INSERT INTO commande_product (prix_vente, prix_revient, prix_achat, quantite, quantite_livre, remise, tva, facturation_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => "137000"
    2 => "120000.00"
    3 => "136800.00"
    4 => 1.0
    5 => 1.0
    6 => "0"
    7 => 0.0
    8 => 605
    9 => 123
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 1
    9 => 1
  ]
]

[
  "sql" => "INSERT INTO livraison (quantite_liv, date_livraison, date_saisie, commentaire, commande_id, saisie_par_id, stock_id) VALUES (?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1.0
    2 => "2026-04-15 11:48:32"
    3 => "2026-04-15 11:48:32"
    4 => "livraison direct"
    5 => 7211
    6 => 1
    7 => 1
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
  ]
]

[
  "sql" => "INSERT INTO mouvement_product (quantite, date_operation, origine, description, stock_product_id, product_id, lieu_vente_id, personnel_id, client_id, inventaire_id, anomalie_id, transfert_id, achat_fournisseur_id, livraison_id, livraison_multiple_id, sortie_stock_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => -1.0
    2 => "2026-04-15 11:48:32"
    3 => "vente direct"
    4 => "vente direct"
    5 => 1
    6 => 123
    7 => 1
    8 => 1
    9 => null
    10 => null
    11 => null
    12 => null
    13 => null
    14 => 6954
    15 => null
    16 => null
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 1
    6 => 1
    7 => 1
    8 => 1
    9 => 1
    10 => 1
    11 => 1
    12 => 1
    13 => 1
    14 => 1
    15 => 1
    16 => 1
  ]
]

[
  "sql" => "UPDATE stock SET quantite = ? WHERE id = ?"
  "params" => [
    1 => 174.0
    2 => 91
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "UPDATE stock SET quantite = ? WHERE id = ?"
  "params" => [
    1 => -3.0
    2 => 141
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "UPDATE stock SET quantite = ? WHERE id = ?"
  "params" => [
    1 => 953.0
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "UPDATE stock SET quantite = ? WHERE id = ?"
  "params" => [
    1 => 43.0
    2 => 515
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "UPDATE stock SET quantite = ? WHERE id = ?"
  "params" => [
    1 => 124.0
    2 => 167
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "UPDATE stock SET quantite = ? WHERE id = ?"
  "params" => [
    1 => 30.0
    2 => 240
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "UPDATE stock SET quantite = ? WHERE id = ?"
  "params" => [
    1 => 74.0
    2 => 123
  ]
  "types" => [
    1 => 2
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.numero_facture AS numero_facture_2, t0.total_facture AS total_facture_3, t0.montant_paye AS montant_paye_4, t0.montant_remise AS montant_remise_5, t0.etat AS etat_6, t0.etat_livraison AS etat_livraison_7, t0.date_facturation AS date_facturation_8, t0.date_saisie AS date_saisie_9, t0.date_alerte AS date_alerte_10, t0.commentaire AS commentaire_11, t0.nom_client_cash AS nom_client_cash_12, t0.frais_sup AS frais_sup_13, t0.taux AS taux_14, t0.client_id AS client_id_15, t0.caisse_id AS caisse_id_16, t0.lieu_vente_id AS lieu_vente_id_17, t0.saisie_par_id AS saisie_par_id_18, t0.mode_paie_id AS mode_paie_id_19, t0.proformat_id AS proformat_id_20, t0.devise_id AS devise_id_21 FROM facturation t0 ORDER BY t0.id DESC LIMIT 1"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.etat AS etat_3, t0.frequence AS frequence_4, t0.message AS message_5 FROM configuration_sms t0 WHERE t0.nom = ? AND t0.etat = ? LIMIT 1"
  "params" => [
    1 => "vente"
    2 => "actif"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

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

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

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

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

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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