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
  count(DISTINCT p0_.id) AS sclr_0
FROM
  piece p0_
  LEFT JOIN client c1_ ON p0_.client_id = c1_.id

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM piece p0_ LEFT JOIN client c1_ ON p0_.client_id = c1_.id;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.id AS id_1
FROM
  piece p0_
  LEFT JOIN client c1_ ON p0_.client_id = c1_.id
ORDER BY
  p0_.id DESC
LIMIT
  20

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM piece p0_ LEFT JOIN client c1_ ON p0_.client_id = c1_.id ORDER BY p0_.id DESC LIMIT 20;

SELECT
  p0_.id AS id_0,
  p0_.date AS date_1,
  p0_.numero AS numero_2,
  p0_.type AS type_3,
  p0_.amount_ht AS amount_ht_4,
  p0_.amount_tva AS amount_tva_5,
  p0_.discount AS discount_6,
  p0_.amount_discount AS amount_discount_7,
  p0_.amount_ttc AS amount_ttc_8,
  p0_.created_at AS created_at_9,
  p0_.updated_at AS updated_at_10,
  p0_.payer AS payer_11,
  p0_.amount_buy_ht AS amount_buy_ht_12,
  p0_.amount_marge AS amount_marge_13,
  p0_.solde AS solde_14,
  p0_.mode_paiement AS mode_paiement_15,
  p0_.amount_discount_total AS amount_discount_total_16,
  c1_.id AS id_17,
  c1_.first_name AS first_name_18,
  c1_.last_name AS last_name_19,
  c1_.email AS email_20,
  c1_.tel AS tel_21,
  c1_.created_at AS created_at_22,
  c1_.updated_at AS updated_at_23,
  c1_.type_client AS type_client_24,
  c1_.address AS address_25,
  c1_.sexe AS sexe_26,
  c1_.date_naissance AS date_naissance_27,
  c1_.poids AS poids_28,
  c1_.taux_graisse AS taux_graisse_29,
  c1_.experience_fitness AS experience_fitness_30,
  c1_.experience_fitness_quoi AS experience_fitness_quoi_31,
  c1_.combiens_annees AS combiens_annees_32,
  c1_.fumez_vous AS fumez_vous_33,
  c1_.buvez_alcool AS buvez_alcool_34,
  c1_.maladie_existant AS maladie_existant_35,
  c1_.traitement AS traitement_36,
  c1_.medicament AS medicament_37,
  c1_.medicament_quoi AS medicament_quoi_38,
  c1_.operation AS operation_39,
  c1_.operation_quoi AS operation_quoi_40,
  c1_.objectif AS objectif_41,
  c1_.remarque AS remarque_42,
  c1_.type_abo AS type_abo_43,
  c1_.date_ref AS date_ref_44,
  c1_.can_edit AS can_edit_45,
  c1_.edit_files AS edit_files_46,
  c1_.edit_fitness AS edit_fitness_47,
  c1_.edit_diete AS edit_diete_48,
  c1_.edit_invoices AS edit_invoices_49,
  p0_.client_id AS client_id_50,
  p0_.user_id AS user_id_51,
  c1_.user_id AS user_id_52
FROM
  piece p0_
  LEFT JOIN client c1_ ON p0_.client_id = c1_.id
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.numero AS numero_2, p0_.type AS type_3, p0_.amount_ht AS amount_ht_4, p0_.amount_tva AS amount_tva_5, p0_.discount AS discount_6, p0_.amount_discount AS amount_discount_7, p0_.amount_ttc AS amount_ttc_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10, p0_.payer AS payer_11, p0_.amount_buy_ht AS amount_buy_ht_12, p0_.amount_marge AS amount_marge_13, p0_.solde AS solde_14, p0_.mode_paiement AS mode_paiement_15, p0_.amount_discount_total AS amount_discount_total_16, c1_.id AS id_17, c1_.first_name AS first_name_18, c1_.last_name AS last_name_19, c1_.email AS email_20, c1_.tel AS tel_21, c1_.created_at AS created_at_22, c1_.updated_at AS updated_at_23, c1_.type_client AS type_client_24, c1_.address AS address_25, c1_.sexe AS sexe_26, c1_.date_naissance AS date_naissance_27, c1_.poids AS poids_28, c1_.taux_graisse AS taux_graisse_29, c1_.experience_fitness AS experience_fitness_30, c1_.experience_fitness_quoi AS experience_fitness_quoi_31, c1_.combiens_annees AS combiens_annees_32, c1_.fumez_vous AS fumez_vous_33, c1_.buvez_alcool AS buvez_alcool_34, c1_.maladie_existant AS maladie_existant_35, c1_.traitement AS traitement_36, c1_.medicament AS medicament_37, c1_.medicament_quoi AS medicament_quoi_38, c1_.operation AS operation_39, c1_.operation_quoi AS operation_quoi_40, c1_.objectif AS objectif_41, c1_.remarque AS remarque_42, c1_.type_abo AS type_abo_43, c1_.date_ref AS date_ref_44, c1_.can_edit AS can_edit_45, c1_.edit_files AS edit_files_46, c1_.edit_fitness AS edit_fitness_47, c1_.edit_diete AS edit_diete_48, c1_.edit_invoices AS edit_invoices_49, p0_.client_id AS client_id_50, p0_.user_id AS user_id_51, c1_.user_id AS user_id_52 FROM piece p0_ LEFT JOIN client c1_ ON p0_.client_id = c1_.id WHERE p0_.id IN (3577, 3576, 3575, 3574, 3573, 3572, 3571, 3570, 3569, 3568, 3567, 3566, 3565, 3564, 3563, 3562, 3561, 3560, 3559, 3558) ORDER BY p0_.id DESC;

SELECT
  SUM(p0_.amount_buy_ht) AS sclr_0,
  SUM(p0_.amount_marge) AS sclr_1,
  SUM(p0_.amount_ht) AS sclr_2,
  SUM(p0_.amount_tva) AS sclr_3,
  SUM(p0_.amount_discount) AS sclr_4,
  SUM(p0_.amount_discount_total) AS sclr_5,
  SUM(p0_.amount_ttc) AS sclr_6,
  SUM(p0_.solde) AS sclr_7
FROM
  piece p0_
  LEFT JOIN client c1_ ON p0_.client_id = c1_.id

SELECT SUM(p0_.amount_buy_ht) AS sclr_0, SUM(p0_.amount_marge) AS sclr_1, SUM(p0_.amount_ht) AS sclr_2, SUM(p0_.amount_tva) AS sclr_3, SUM(p0_.amount_discount) AS sclr_4, SUM(p0_.amount_discount_total) AS sclr_5, SUM(p0_.amount_ttc) AS sclr_6, SUM(p0_.solde) AS sclr_7 FROM piece p0_ LEFT JOIN client c1_ ON p0_.client_id = c1_.id;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.first_name AS first_name_4,
  u0_.last_name AS last_name_5,
  u0_.tel AS tel_6,
  u0_.role AS role_7,
  u0_.avatar AS avatar_8,
  u0_.active AS active_9,
  u0_.token AS token_10,
  u0_.created_at AS created_at_11,
  u0_.updated_at AS updated_at_12
FROM
  user u0_
ORDER BY
  u0_.last_name ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.tel AS tel_6, u0_.role AS role_7, u0_.avatar AS avatar_8, u0_.active AS active_9, u0_.token AS token_10, u0_.created_at AS created_at_11, u0_.updated_at AS updated_at_12 FROM user u0_ ORDER BY u0_.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 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;