Symfony Profiler

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.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.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.tel AS tel_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.type_client AS type_client_8,
  t0.address AS address_9,
  t0.sexe AS sexe_10,
  t0.date_naissance AS date_naissance_11,
  t0.poids AS poids_12,
  t0.taux_graisse AS taux_graisse_13,
  t0.experience_fitness AS experience_fitness_14,
  t0.experience_fitness_quoi AS experience_fitness_quoi_15,
  t0.combiens_annees AS combiens_annees_16,
  t0.fumez_vous AS fumez_vous_17,
  t0.buvez_alcool AS buvez_alcool_18,
  t0.maladie_existant AS maladie_existant_19,
  t0.traitement AS traitement_20,
  t0.medicament AS medicament_21,
  t0.medicament_quoi AS medicament_quoi_22,
  t0.operation AS operation_23,
  t0.operation_quoi AS operation_quoi_24,
  t0.objectif AS objectif_25,
  t0.remarque AS remarque_26,
  t0.type_abo AS type_abo_27,
  t0.date_ref AS date_ref_28,
  t0.can_edit AS can_edit_29,
  t0.edit_files AS edit_files_30,
  t0.edit_fitness AS edit_fitness_31,
  t0.edit_diete AS edit_diete_32,
  t0.edit_invoices AS edit_invoices_33,
  t0.user_id AS user_id_34
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.tel AS tel_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type_client AS type_client_8, t0.address AS address_9, t0.sexe AS sexe_10, t0.date_naissance AS date_naissance_11, t0.poids AS poids_12, t0.taux_graisse AS taux_graisse_13, t0.experience_fitness AS experience_fitness_14, t0.experience_fitness_quoi AS experience_fitness_quoi_15, t0.combiens_annees AS combiens_annees_16, t0.fumez_vous AS fumez_vous_17, t0.buvez_alcool AS buvez_alcool_18, t0.maladie_existant AS maladie_existant_19, t0.traitement AS traitement_20, t0.medicament AS medicament_21, t0.medicament_quoi AS medicament_quoi_22, t0.operation AS operation_23, t0.operation_quoi AS operation_quoi_24, t0.objectif AS objectif_25, t0.remarque AS remarque_26, t0.type_abo AS type_abo_27, t0.date_ref AS date_ref_28, t0.can_edit AS can_edit_29, t0.edit_files AS edit_files_30, t0.edit_fitness AS edit_fitness_31, t0.edit_diete AS edit_diete_32, t0.edit_invoices AS edit_invoices_33, t0.user_id AS user_id_34 FROM client t0 WHERE t0.id = 265;

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

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

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.numero AS numero_3,
  t0.type AS type_4,
  t0.amount_ht AS amount_ht_5,
  t0.amount_tva AS amount_tva_6,
  t0.discount AS discount_7,
  t0.amount_discount AS amount_discount_8,
  t0.amount_ttc AS amount_ttc_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.payer AS payer_12,
  t0.amount_buy_ht AS amount_buy_ht_13,
  t0.amount_marge AS amount_marge_14,
  t0.solde AS solde_15,
  t0.mode_paiement AS mode_paiement_16,
  t0.amount_discount_total AS amount_discount_total_17,
  t0.client_id AS client_id_18,
  t0.user_id AS user_id_19
FROM
  piece t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.numero AS numero_3, t0.type AS type_4, t0.amount_ht AS amount_ht_5, t0.amount_tva AS amount_tva_6, t0.discount AS discount_7, t0.amount_discount AS amount_discount_8, t0.amount_ttc AS amount_ttc_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.payer AS payer_12, t0.amount_buy_ht AS amount_buy_ht_13, t0.amount_marge AS amount_marge_14, t0.solde AS solde_15, t0.mode_paiement AS mode_paiement_16, t0.amount_discount_total AS amount_discount_total_17, t0.client_id AS client_id_18, t0.user_id AS user_id_19 FROM piece t0 WHERE t0.id = '4271';

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.price_ht AS price_ht_4,
  t0.qty AS qty_5,
  t0.tva AS tva_6,
  t0.total_ht AS total_ht_7,
  t0.marge AS marge_8,
  t0.price_buy_ht AS price_buy_ht_9,
  t0.rabais AS rabais_10,
  t0.amount_rabais AS amount_rabais_11,
  t0.piece_id AS piece_id_12,
  t0.product_id AS product_id_13,
  t0.lot_id AS lot_id_14
FROM
  piece_line t0
WHERE
  t0.piece_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.price_ht AS price_ht_4, t0.qty AS qty_5, t0.tva AS tva_6, t0.total_ht AS total_ht_7, t0.marge AS marge_8, t0.price_buy_ht AS price_buy_ht_9, t0.rabais AS rabais_10, t0.amount_rabais AS amount_rabais_11, t0.piece_id AS piece_id_12, t0.product_id AS product_id_13, t0.lot_id AS lot_id_14 FROM piece_line t0 WHERE t0.piece_id = 4271;

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_
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_ ORDER BY c0_.first_name ASC, c0_.last_name ASC;

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