Symfony Profiler

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.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.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
  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_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.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';

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.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
  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;

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.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 = 'eu' LIMIT 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 = 'us' LIMIT 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 = 'cfa' 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 = 91;

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

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

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

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

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

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

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

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

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

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