Symfony Profiler

SELECT
  sum(s0_.quantite) AS sclr_0
FROM
  stock s0_
WHERE
  s0_.product_id = NULL

SELECT sum(s0_.quantite) AS sclr_0 FROM stock s0_ WHERE s0_.product_id = NULL;

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
  c0_.id AS id_0,
  c0_.designation AS designation_1,
  c0_.type AS type_2,
  c0_.numero_compte AS numero_compte_3,
  c0_.document AS document_4,
  c0_.point_de_vente_id AS point_de_vente_id_5
FROM
  caisse c0_
  LEFT JOIN point_de_vente p1_ ON (
    c0_.point_de_vente_id = p1_.id
    OR c0_.point_de_vente_id IS NULL
  )
WHERE
  c0_.type = ?
  AND p1_.lieu_vente_id = ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.numero_compte AS numero_compte_3, c0_.document AS document_4, c0_.point_de_vente_id AS point_de_vente_id_5 FROM caisse c0_ LEFT JOIN point_de_vente p1_ ON (c0_.point_de_vente_id = p1_.id OR c0_.point_de_vente_id IS NULL) WHERE c0_.type = 'banque' AND p1_.lieu_vente_id = 1 ORDER BY c0_.id ASC;

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
  c0_.id AS id_0,
  c0_.designation AS designation_1,
  c0_.type AS type_2,
  c0_.numero_compte AS numero_compte_3,
  c0_.document AS document_4,
  c0_.point_de_vente_id AS point_de_vente_id_5
FROM
  caisse c0_
  LEFT JOIN point_de_vente p1_ ON (
    c0_.point_de_vente_id = p1_.id
    OR c0_.point_de_vente_id IS NULL
  )
WHERE
  p1_.lieu_vente_id = ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.designation AS designation_1, c0_.type AS type_2, c0_.numero_compte AS numero_compte_3, c0_.document AS document_4, c0_.point_de_vente_id AS point_de_vente_id_5 FROM caisse c0_ LEFT JOIN point_de_vente p1_ ON (c0_.point_de_vente_id = p1_.id OR c0_.point_de_vente_id IS NULL) WHERE p1_.lieu_vente_id = 1 ORDER BY c0_.id ASC;

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
  INNER JOIN personnel_liste_stock ON t0.id = personnel_liste_stock.liste_stock_id
WHERE
  personnel_liste_stock.personnel_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 INNER JOIN personnel_liste_stock ON t0.id = personnel_liste_stock.liste_stock_id WHERE personnel_liste_stock.personnel_id = 1;

SELECT
  t0.id AS id_1,
  t0.taux AS taux_2,
  t0.devise_id AS devise_id_3,
  t0.lieu_vente_id AS lieu_vente_id_4
FROM
  taux_devise t0
WHERE
  t0.lieu_vente_id = ?

SELECT t0.id AS id_1, t0.taux AS taux_2, t0.devise_id AS devise_id_3, t0.lieu_vente_id AS lieu_vente_id_4 FROM taux_devise t0 WHERE t0.lieu_vente_id = 1;

SELECT
  t0.id AS id_1,
  t0.color AS color_2,
  t0.background_color AS background_color_3,
  t0.livraison AS livraison_4,
  t0.caisse AS caisse_5,
  t0.format_facture AS format_facture_6,
  t0.long_logo AS long_logo_7,
  t0.larg_logo AS larg_logo_8,
  t0.nom_entreprise AS nom_entreprise_9,
  t0.compte_client_fournisseur AS compte_client_fournisseur_10,
  t0.affichage_vente_compte AS affichage_vente_compte_11,
  t0.chemin_sauvegarde AS chemin_sauvegarde_12,
  t0.chemin_mysql AS chemin_mysql_13,
  t0.vente_stock AS vente_stock_14
FROM
  configuration_logiciel t0
LIMIT
  1

SELECT t0.id AS id_1, t0.color AS color_2, t0.background_color AS background_color_3, t0.livraison AS livraison_4, t0.caisse AS caisse_5, t0.format_facture AS format_facture_6, t0.long_logo AS long_logo_7, t0.larg_logo AS larg_logo_8, t0.nom_entreprise AS nom_entreprise_9, t0.compte_client_fournisseur AS compte_client_fournisseur_10, t0.affichage_vente_compte AS affichage_vente_compte_11, t0.chemin_sauvegarde AS chemin_sauvegarde_12, t0.chemin_mysql AS chemin_mysql_13, t0.vente_stock AS vente_stock_14 FROM configuration_logiciel t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.fonction AS fonction_2,
  t0.document_identite AS document_identite_3,
  t0.type_paie AS type_paie_4,
  t0.taux_horaire AS taux_horaire_5,
  t0.salaire_base AS salaire_base_6,
  t0.photo_identite AS photo_identite_7,
  t0.signature AS signature_8,
  t0.user_id AS user_id_9
FROM
  personnel t0
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.fonction AS fonction_2, t0.document_identite AS document_identite_3, t0.type_paie AS type_paie_4, t0.taux_horaire AS taux_horaire_5, t0.salaire_base AS salaire_base_6, t0.photo_identite AS photo_identite_7, t0.signature AS signature_8, t0.user_id AS user_id_9 FROM personnel t0 WHERE t0.user_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2
FROM
  mode_paiement t0

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

SELECT
  t0.id AS id_1,
  t0.nom_devise AS nom_devise_2
FROM
  devise t0

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

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2
FROM
  frais_sup t0

SELECT t0.id AS id_1, t0.designation AS designation_2 FROM frais_sup t0;