Symfony Profiler

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 = ?

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

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 = ?

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

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

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 = 1 AND t0.product_id = 306 LIMIT 1;

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

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 = 306 AND t0.stock_produit_id = 1 LIMIT 1;

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 = ?

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

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
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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 (-1, '2026-04-17 16:39:47', 'vente direct', 'vente direct', 1, 306, 1, 1, NULL, NULL, NULL, NULL, NULL, 7089, NULL, NULL);

INSERT INTO commande_product (
  prix_vente, prix_revient, prix_achat,
  quantite, quantite_livre, remise,
  tva, facturation_id, product_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO commande_product (prix_vente, prix_revient, prix_achat, quantite, quantite_livre, remise, tva, facturation_id, product_id) VALUES ('50000', '41000.00', '36000.00', 1, 1, '0', 0, 619, 306);

INSERT INTO livraison (
  quantite_liv, date_livraison, date_saisie,
  commentaire, commande_id, saisie_par_id,
  stock_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO livraison (quantite_liv, date_livraison, date_saisie, commentaire, commande_id, saisie_par_id, stock_id) VALUES (1, '2026-04-17 16:39:47', '2026-04-17 16:39:47', 'livraison direct', 7346, 1, 1);

UPDATE
  stock
SET
  quantite = ?
WHERE
  id = ?

UPDATE stock SET quantite = 41 WHERE id = 306;

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2
FROM
  mode_paiement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.designation AS designation_2 FROM mode_paiement t0 WHERE t0.id = 1;

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 = ?

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

SELECT
  t0.id AS id_1,
  t0.nom_devise AS nom_devise_2
FROM
  devise t0
WHERE
  t0.nom_devise = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom_devise AS nom_devise_2 FROM devise t0 WHERE t0.nom_devise = 'gnf' LIMIT 1;

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

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 = 451 AND (s0_.prix_achat > 0 OR s0_.prix_revient > 0) AND l1_.lieu_vente_id = 1 ORDER BY s0_.id DESC LIMIT 1;

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
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

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 ('acf260619', '1450000', '1450000', '0', 'payé', 'livré', '2026-04-17 16:39:47', '2026-04-17 16:39:47', NULL, NULL, NULL, '0', NULL, NULL, 1, 1, 1, 1, NULL, NULL);

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
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

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 ('facturation', '1450000', '2026-04-17 16:39:47', '2026-04-17 16:39:47', NULL, NULL, 1, 'non traite', NULL, NULL, NULL, 1, 1, 1, 6, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 619, 1, NULL, NULL, 1, NULL, NULL);

SELECT
  MAX(f0_.id) AS sclr_0
FROM
  facturation f0_

SELECT MAX(f0_.id) AS sclr_0 FROM facturation f0_;

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

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 = 'vente' AND t0.etat = 'actif' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom_devise AS nom_devise_2
FROM
  devise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_devise AS nom_devise_2 FROM devise t0 WHERE t0.id = 1;

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 = ?

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 = '1';

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

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;

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 = ?

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

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 = ?

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 = '1';

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.nom_operation AS nom_operation_2
FROM
  categorie_operation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_operation AS nom_operation_2 FROM categorie_operation t0 WHERE t0.id = 1;

"COMMIT"

"COMMIT";