Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.tel AS tel_7,
  t0.role AS role_8,
  t0.avatar AS avatar_9,
  t0.active AS active_10,
  t0.token AS token_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.tel AS tel_7, t0.role AS role_8, t0.avatar AS avatar_9, t0.active AS active_10, t0.token AS token_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM user t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.tva AS tva_2,
  t0.name AS name_3,
  t0.address AS address_4,
  t0.tel AS tel_5,
  t0.email AS email_6,
  t0.web AS web_7,
  t0.code_tva AS code_tva_8,
  t0.logo AS logo_9,
  t0.tva_active AS tva_active_10,
  t0.updated_at AS updated_at_11
FROM
  configuration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.tva AS tva_2, t0.name AS name_3, t0.address AS address_4, t0.tel AS tel_5, t0.email AS email_6, t0.web AS web_7, t0.code_tva AS code_tva_8, t0.logo AS logo_9, t0.tva_active AS tva_active_10, t0.updated_at AS updated_at_11 FROM configuration t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.sell_ht AS sell_ht_4,
  t0.buy_ht AS buy_ht_5,
  t0.stock AS stock_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.photo AS photo_9,
  t0.taille_poids AS taille_poids_10,
  t0.marque AS marque_11,
  t0.date_expiration AS date_expiration_12,
  t0.marge AS marge_13,
  t0.barecode AS barecode_14
FROM
  product t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.sell_ht AS sell_ht_4, t0.buy_ht AS buy_ht_5, t0.stock AS stock_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.photo AS photo_9, t0.taille_poids AS taille_poids_10, t0.marque AS marque_11, t0.date_expiration AS date_expiration_12, t0.marge AS marge_13, t0.barecode AS barecode_14 FROM product t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1637;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1633;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1632;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1635;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1634;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1636;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1639;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1641;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1661;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1660;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1625;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1656;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1659;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1638;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1631;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1648;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1652;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1649;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1658;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1629;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1630;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1655;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1628;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1650;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1617;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1619;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1644;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1651;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1647;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1646;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1645;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1657;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1618;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1620;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1640;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1662;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1616;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1654;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1653;

SELECT
  t0.id AS id_1,
  t0.stock AS stock_2,
  t0.date_expiration AS date_expiration_3,
  t0.product_id AS product_id_4
FROM
  lot t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.stock AS stock_2, t0.date_expiration AS date_expiration_3, t0.product_id AS product_id_4 FROM lot t0 WHERE t0.product_id = 1643;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.sell_ht AS sell_ht_4,
  t0.buy_ht AS buy_ht_5,
  t0.stock AS stock_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.photo AS photo_9,
  t0.taille_poids AS taille_poids_10,
  t0.marque AS marque_11,
  t0.date_expiration AS date_expiration_12,
  t0.marge AS marge_13,
  t0.barecode AS barecode_14
FROM
  product t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.sell_ht AS sell_ht_4, t0.buy_ht AS buy_ht_5, t0.stock AS stock_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.photo AS photo_9, t0.taille_poids AS taille_poids_10, t0.marque AS marque_11, t0.date_expiration AS date_expiration_12, t0.marge AS marge_13, t0.barecode AS barecode_14 FROM product t0 ORDER BY t0.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.first_name AS first_name_1,
  c0_.last_name AS last_name_2,
  c0_.email AS email_3,
  c0_.tel AS tel_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  c0_.type_client AS type_client_7,
  c0_.address AS address_8,
  c0_.sexe AS sexe_9,
  c0_.date_naissance AS date_naissance_10,
  c0_.poids AS poids_11,
  c0_.taux_graisse AS taux_graisse_12,
  c0_.experience_fitness AS experience_fitness_13,
  c0_.experience_fitness_quoi AS experience_fitness_quoi_14,
  c0_.combiens_annees AS combiens_annees_15,
  c0_.fumez_vous AS fumez_vous_16,
  c0_.buvez_alcool AS buvez_alcool_17,
  c0_.maladie_existant AS maladie_existant_18,
  c0_.traitement AS traitement_19,
  c0_.medicament AS medicament_20,
  c0_.medicament_quoi AS medicament_quoi_21,
  c0_.operation AS operation_22,
  c0_.operation_quoi AS operation_quoi_23,
  c0_.objectif AS objectif_24,
  c0_.remarque AS remarque_25,
  c0_.type_abo AS type_abo_26,
  c0_.date_ref AS date_ref_27,
  c0_.can_edit AS can_edit_28,
  c0_.edit_files AS edit_files_29,
  c0_.edit_fitness AS edit_fitness_30,
  c0_.edit_diete AS edit_diete_31,
  c0_.edit_invoices AS edit_invoices_32,
  c0_.user_id AS user_id_33
FROM
  client c0_
WHERE
  c0_.id IN (?)
ORDER BY
  c0_.first_name ASC,
  c0_.last_name ASC

SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.email AS email_3, c0_.tel AS tel_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.type_client AS type_client_7, c0_.address AS address_8, c0_.sexe AS sexe_9, c0_.date_naissance AS date_naissance_10, c0_.poids AS poids_11, c0_.taux_graisse AS taux_graisse_12, c0_.experience_fitness AS experience_fitness_13, c0_.experience_fitness_quoi AS experience_fitness_quoi_14, c0_.combiens_annees AS combiens_annees_15, c0_.fumez_vous AS fumez_vous_16, c0_.buvez_alcool AS buvez_alcool_17, c0_.maladie_existant AS maladie_existant_18, c0_.traitement AS traitement_19, c0_.medicament AS medicament_20, c0_.medicament_quoi AS medicament_quoi_21, c0_.operation AS operation_22, c0_.operation_quoi AS operation_quoi_23, c0_.objectif AS objectif_24, c0_.remarque AS remarque_25, c0_.type_abo AS type_abo_26, c0_.date_ref AS date_ref_27, c0_.can_edit AS can_edit_28, c0_.edit_files AS edit_files_29, c0_.edit_fitness AS edit_fitness_30, c0_.edit_diete AS edit_diete_31, c0_.edit_invoices AS edit_invoices_32, c0_.user_id AS user_id_33 FROM client c0_ WHERE c0_.id IN ('259') ORDER BY c0_.first_name ASC, c0_.last_name ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.sell_ht AS sell_ht_4,
  t0.buy_ht AS buy_ht_5,
  t0.stock AS stock_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.photo AS photo_9,
  t0.taille_poids AS taille_poids_10,
  t0.marque AS marque_11,
  t0.date_expiration AS date_expiration_12,
  t0.marge AS marge_13,
  t0.barecode AS barecode_14
FROM
  product t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.sell_ht AS sell_ht_4, t0.buy_ht AS buy_ht_5, t0.stock AS stock_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.photo AS photo_9, t0.taille_poids AS taille_poids_10, t0.marque AS marque_11, t0.date_expiration AS date_expiration_12, t0.marge AS marge_13, t0.barecode AS barecode_14 FROM product t0 ORDER BY t0.name ASC;

SELECT
  l0_.id AS id_0,
  l0_.stock AS stock_1,
  l0_.date_expiration AS date_expiration_2,
  l0_.product_id AS product_id_3
FROM
  lot l0_
WHERE
  l0_.product_id = ?
  AND l0_.id IN (?)

SELECT l0_.id AS id_0, l0_.stock AS stock_1, l0_.date_expiration AS date_expiration_2, l0_.product_id AS product_id_3 FROM lot l0_ WHERE l0_.product_id = '1641' AND l0_.id IN ('1889');

SELECT
  l0_.id AS id_0,
  l0_.stock AS stock_1,
  l0_.date_expiration AS date_expiration_2,
  l0_.product_id AS product_id_3
FROM
  lot l0_
WHERE
  l0_.product_id = ?
  AND l0_.id IN (?)

SELECT l0_.id AS id_0, l0_.stock AS stock_1, l0_.date_expiration AS date_expiration_2, l0_.product_id AS product_id_3 FROM lot l0_ WHERE l0_.product_id = '1650' AND l0_.id IN ('1898');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO piece (
  date, numero, type, amount_ht, amount_tva,
  discount, amount_discount, amount_ttc,
  created_at, updated_at, payer, amount_buy_ht,
  amount_marge, solde, mode_paiement,
  amount_discount_total, client_id,
  user_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO piece (date, numero, type, amount_ht, amount_tva, discount, amount_discount, amount_ttc, created_at, updated_at, payer, amount_buy_ht, amount_marge, solde, mode_paiement, amount_discount_total, client_id, user_id) VALUES ('2025-07-19', 3071, NULL, '8.00', '0.00', NULL, '0.00', '8.00', '2025-07-19 21:12:02', '2025-07-19 21:12:02', NULL, '2.00', '6.00', '8.00', NULL, '0.00', 259, 2);

INSERT INTO piece_line (
  code, name, price_ht, qty, tva, total_ht,
  marge, price_buy_ht, rabais, amount_rabais,
  piece_id, product_id, lot_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO piece_line (code, name, price_ht, qty, tva, total_ht, marge, price_buy_ht, rabais, amount_rabais, piece_id, product_id, lot_id) VALUES (NULL, NULL, '5.00', 1, NULL, '5.00', '4.00', '1.00', NULL, '0.00', 4388, 1641, 1889);