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.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
WHERE
  t0.id = ?

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 WHERE t0.id = '605';

SELECT
  sum(m0_.montant) AS sclr_0,
  d1_.nom_devise AS nom_devise_1
FROM
  mouvement_collaborateur m0_
  LEFT JOIN devise d1_ ON m0_.devise_id = d1_.id
WHERE
  m0_.collaborateur_id = ?
GROUP BY
  m0_.devise_id

SELECT sum(m0_.montant) AS sclr_0, d1_.nom_devise AS nom_devise_1 FROM mouvement_collaborateur m0_ LEFT JOIN devise d1_ ON m0_.devise_id = d1_.id WHERE m0_.collaborateur_id = NULL GROUP BY m0_.devise_id;

SELECT
  t0.id AS id_1,
  t0.nom_entreprise AS nom_entreprise_2,
  t0.identifiant AS identifiant_3,
  t0.numero_agrement AS numero_agrement_4,
  t0.adresse AS adresse_5,
  t0.telephone AS telephone_6,
  t0.logo AS logo_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9
FROM
  entreprise t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom_entreprise AS nom_entreprise_2, t0.identifiant AS identifiant_3, t0.numero_agrement AS numero_agrement_4, t0.adresse AS adresse_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9 FROM entreprise t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.prix_vente AS prix_vente_2,
  t0.prix_revient AS prix_revient_3,
  t0.prix_achat AS prix_achat_4,
  t0.quantite AS quantite_5,
  t0.quantite_livre AS quantite_livre_6,
  t0.remise AS remise_7,
  t0.tva AS tva_8,
  t0.facturation_id AS facturation_id_9,
  t0.product_id AS product_id_10
FROM
  commande_product t0
WHERE
  t0.facturation_id = ?
ORDER BY
  t0.product_id ASC

SELECT t0.id AS id_1, t0.prix_vente AS prix_vente_2, t0.prix_revient AS prix_revient_3, t0.prix_achat AS prix_achat_4, t0.quantite AS quantite_5, t0.quantite_livre AS quantite_livre_6, t0.remise AS remise_7, t0.tva AS tva_8, t0.facturation_id AS facturation_id_9, t0.product_id AS product_id_10 FROM commande_product t0 WHERE t0.facturation_id = 605 ORDER BY t0.product_id ASC;

SELECT
  t0.id AS id_1,
  t0.type_mouvement AS type_mouvement_2,
  t0.montant AS montant_3,
  t0.date_operation AS date_operation_4,
  t0.date_saisie AS date_saisie_5,
  t0.numero_paie AS numero_paie_6,
  t0.banque_cheque AS banque_cheque_7,
  t0.taux AS taux_8,
  t0.etat_operation AS etat_operation_9,
  t0.date_sortie AS date_sortie_10,
  t0.type_sortie AS type_sortie_11,
  t0.detail_sortie AS detail_sortie_12,
  t0.lieu_vente_id AS lieu_vente_id_13,
  t0.caisse_id AS caisse_id_14,
  t0.categorie_operation_id AS categorie_operation_id_15,
  t0.compte_operation_id AS compte_operation_id_16,
  t0.devise_id AS devise_id_17,
  t0.decaissement_id AS decaissement_id_18,
  t0.avance_salaire_id AS avance_salaire_id_19,
  t0.paiement_salaire_id AS paiement_salaire_id_20,
  t0.depense_id AS depense_id_21,
  t0.versement_id AS versement_id_22,
  t0.transfert_fond_id AS transfert_fond_id_23,
  t0.cheque_espece_id AS cheque_espece_id_24,
  t0.recette_id AS recette_id_25,
  t0.facturation_id AS facturation_id_26,
  t0.mode_paie_id AS mode_paie_id_27,
  t0.retour_product_id AS retour_product_id_28,
  t0.echange_id AS echange_id_29,
  t0.saisie_par_id AS saisie_par_id_30,
  t0.cloture_id AS cloture_id_31,
  t0.sortie_stock_id AS sortie_stock_id_32
FROM
  mouvement_caisse t0
WHERE
  t0.facturation_id = ?

SELECT t0.id AS id_1, t0.type_mouvement AS type_mouvement_2, t0.montant AS montant_3, t0.date_operation AS date_operation_4, t0.date_saisie AS date_saisie_5, t0.numero_paie AS numero_paie_6, t0.banque_cheque AS banque_cheque_7, t0.taux AS taux_8, t0.etat_operation AS etat_operation_9, t0.date_sortie AS date_sortie_10, t0.type_sortie AS type_sortie_11, t0.detail_sortie AS detail_sortie_12, t0.lieu_vente_id AS lieu_vente_id_13, t0.caisse_id AS caisse_id_14, t0.categorie_operation_id AS categorie_operation_id_15, t0.compte_operation_id AS compte_operation_id_16, t0.devise_id AS devise_id_17, t0.decaissement_id AS decaissement_id_18, t0.avance_salaire_id AS avance_salaire_id_19, t0.paiement_salaire_id AS paiement_salaire_id_20, t0.depense_id AS depense_id_21, t0.versement_id AS versement_id_22, t0.transfert_fond_id AS transfert_fond_id_23, t0.cheque_espece_id AS cheque_espece_id_24, t0.recette_id AS recette_id_25, t0.facturation_id AS facturation_id_26, t0.mode_paie_id AS mode_paie_id_27, t0.retour_product_id AS retour_product_id_28, t0.echange_id AS echange_id_29, t0.saisie_par_id AS saisie_par_id_30, t0.cloture_id AS cloture_id_31, t0.sortie_stock_id AS sortie_stock_id_32 FROM mouvement_caisse t0 WHERE t0.facturation_id = 605;

SELECT
  t0.id AS id_1,
  t0.montant AS montant_2,
  t0.facturation_id AS facturation_id_3,
  t0.frais_sup_id AS frais_sup_id_4,
  t0.devise_id AS devise_id_5
FROM
  facture_frais_sup t0
WHERE
  t0.facturation_id = ?

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.facturation_id AS facturation_id_3, t0.frais_sup_id AS frais_sup_id_4, t0.devise_id AS devise_id_5 FROM facture_frais_sup t0 WHERE t0.facturation_id = 605;

SELECT
  t0.id AS id_1,
  t0.total_facture AS total_facture_2,
  t0.montant_paye AS montant_paye_3,
  t0.montant_remise AS montant_remise_4,
  t0.frais_sup AS frais_sup_5,
  t0.nom_client_cash AS nom_client_cash_6,
  t0.etat AS etat_7,
  t0.etat_livraison AS etat_livraison_8,
  t0.date_facturation AS date_facturation_9,
  t0.date_saisie AS date_saisie_10,
  t0.facture_id AS facture_id_11,
  t0.caisse_id AS caisse_id_12,
  t0.lieu_vente_id AS lieu_vente_id_13,
  t0.saisie_par_id AS saisie_par_id_14,
  t0.client_id AS client_id_15,
  t0.mode_paie_id AS mode_paie_id_16
FROM
  modification_facture t0
WHERE
  t0.facture_id = ?

SELECT t0.id AS id_1, t0.total_facture AS total_facture_2, t0.montant_paye AS montant_paye_3, t0.montant_remise AS montant_remise_4, t0.frais_sup AS frais_sup_5, t0.nom_client_cash AS nom_client_cash_6, t0.etat AS etat_7, t0.etat_livraison AS etat_livraison_8, t0.date_facturation AS date_facturation_9, t0.date_saisie AS date_saisie_10, t0.facture_id AS facture_id_11, t0.caisse_id AS caisse_id_12, t0.lieu_vente_id AS lieu_vente_id_13, t0.saisie_par_id AS saisie_par_id_14, t0.client_id AS client_id_15, t0.mode_paie_id AS mode_paie_id_16 FROM modification_facture t0 WHERE t0.facture_id = 605;

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

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