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.active AS active_7,
  t0.must_change_password AS must_change_password_8,
  t0.created_at AS created_at_9,
  t0.last_login_at AS last_login_at_10,
  t0.password_changed_at AS password_changed_at_11,
  t0.created_by_id AS created_by_id_12
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.active AS active_7, t0.must_change_password AS must_change_password_8, t0.created_at AS created_at_9, t0.last_login_at AS last_login_at_10, t0.password_changed_at AS password_changed_at_11, t0.created_by_id AS created_by_id_12 FROM user t0 WHERE t0.id = 3;

SELECT
  i0_.id AS id_0,
  i0_.type AS type_1,
  i0_.numero AS numero_2,
  i0_.date AS date_3,
  i0_.reference AS reference_4,
  i0_.client_nom AS client_nom_5,
  i0_.client_compte AS client_compte_6,
  i0_.client_extra AS client_extra_7,
  i0_.show_words AS show_words_8,
  i0_.upper AS upper_9,
  i0_.total AS total_10,
  i0_.created_at AS created_at_11,
  i0_.updated_at AS updated_at_12,
  COALESCE(
    SUM(p1_.amount),
    0
  ) AS sclr_13,
  i0_.client_id AS client_id_14,
  i0_.created_by_id AS created_by_id_15
FROM
  invoice i0_
  LEFT JOIN payment p1_ ON i0_.id = p1_.invoice_id
GROUP BY
  i0_.id
ORDER BY
  i0_.date DESC,
  i0_.id DESC
LIMIT
  200

SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.numero AS numero_2, i0_.date AS date_3, i0_.reference AS reference_4, i0_.client_nom AS client_nom_5, i0_.client_compte AS client_compte_6, i0_.client_extra AS client_extra_7, i0_.show_words AS show_words_8, i0_.upper AS upper_9, i0_.total AS total_10, i0_.created_at AS created_at_11, i0_.updated_at AS updated_at_12, COALESCE(SUM(p1_.amount), 0) AS sclr_13, i0_.client_id AS client_id_14, i0_.created_by_id AS created_by_id_15 FROM invoice i0_ LEFT JOIN payment p1_ ON i0_.id = p1_.invoice_id GROUP BY i0_.id ORDER BY i0_.date DESC, i0_.id DESC LIMIT 200;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.amount AS amount_3,
  t0.method AS method_4,
  t0.note AS note_5,
  t0.receipt_number AS receipt_number_6,
  t0.created_at AS created_at_7,
  t0.invoice_id AS invoice_id_8,
  t0.created_by_id AS created_by_id_9
FROM
  payment t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.date ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.method AS method_4, t0.note AS note_5, t0.receipt_number AS receipt_number_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8, t0.created_by_id AS created_by_id_9 FROM payment t0 WHERE t0.invoice_id = 3 ORDER BY t0.date ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.ref AS ref_3,
  t0.designation AS designation_4,
  t0.qte AS qte_5,
  t0.pu AS pu_6,
  t0.invoice_id AS invoice_id_7
FROM
  invoice_line t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.ref AS ref_3, t0.designation AS designation_4, t0.qte AS qte_5, t0.pu AS pu_6, t0.invoice_id AS invoice_id_7 FROM invoice_line t0 WHERE t0.invoice_id = 3 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.amount AS amount_3,
  t0.method AS method_4,
  t0.note AS note_5,
  t0.receipt_number AS receipt_number_6,
  t0.created_at AS created_at_7,
  t0.invoice_id AS invoice_id_8,
  t0.created_by_id AS created_by_id_9
FROM
  payment t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.date ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.method AS method_4, t0.note AS note_5, t0.receipt_number AS receipt_number_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8, t0.created_by_id AS created_by_id_9 FROM payment t0 WHERE t0.invoice_id = 2 ORDER BY t0.date ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.ref AS ref_3,
  t0.designation AS designation_4,
  t0.qte AS qte_5,
  t0.pu AS pu_6,
  t0.invoice_id AS invoice_id_7
FROM
  invoice_line t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.ref AS ref_3, t0.designation AS designation_4, t0.qte AS qte_5, t0.pu AS pu_6, t0.invoice_id AS invoice_id_7 FROM invoice_line t0 WHERE t0.invoice_id = 2 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.amount AS amount_3,
  t0.method AS method_4,
  t0.note AS note_5,
  t0.receipt_number AS receipt_number_6,
  t0.created_at AS created_at_7,
  t0.invoice_id AS invoice_id_8,
  t0.created_by_id AS created_by_id_9
FROM
  payment t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.date ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.method AS method_4, t0.note AS note_5, t0.receipt_number AS receipt_number_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8, t0.created_by_id AS created_by_id_9 FROM payment t0 WHERE t0.invoice_id = 1 ORDER BY t0.date ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.ref AS ref_3,
  t0.designation AS designation_4,
  t0.qte AS qte_5,
  t0.pu AS pu_6,
  t0.invoice_id AS invoice_id_7
FROM
  invoice_line t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.ref AS ref_3, t0.designation AS designation_4, t0.qte AS qte_5, t0.pu AS pu_6, t0.invoice_id AS invoice_id_7 FROM invoice_line t0 WHERE t0.invoice_id = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.amount AS amount_3,
  t0.method AS method_4,
  t0.note AS note_5,
  t0.receipt_number AS receipt_number_6,
  t0.created_at AS created_at_7,
  t0.invoice_id AS invoice_id_8,
  t0.created_by_id AS created_by_id_9
FROM
  payment t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.date ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.method AS method_4, t0.note AS note_5, t0.receipt_number AS receipt_number_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8, t0.created_by_id AS created_by_id_9 FROM payment t0 WHERE t0.invoice_id = 6 ORDER BY t0.date ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.ref AS ref_3,
  t0.designation AS designation_4,
  t0.qte AS qte_5,
  t0.pu AS pu_6,
  t0.invoice_id AS invoice_id_7
FROM
  invoice_line t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.ref AS ref_3, t0.designation AS designation_4, t0.qte AS qte_5, t0.pu AS pu_6, t0.invoice_id AS invoice_id_7 FROM invoice_line t0 WHERE t0.invoice_id = 6 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.amount AS amount_3,
  t0.method AS method_4,
  t0.note AS note_5,
  t0.receipt_number AS receipt_number_6,
  t0.created_at AS created_at_7,
  t0.invoice_id AS invoice_id_8,
  t0.created_by_id AS created_by_id_9
FROM
  payment t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.date ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.method AS method_4, t0.note AS note_5, t0.receipt_number AS receipt_number_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8, t0.created_by_id AS created_by_id_9 FROM payment t0 WHERE t0.invoice_id = 5 ORDER BY t0.date ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.ref AS ref_3,
  t0.designation AS designation_4,
  t0.qte AS qte_5,
  t0.pu AS pu_6,
  t0.invoice_id AS invoice_id_7
FROM
  invoice_line t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.ref AS ref_3, t0.designation AS designation_4, t0.qte AS qte_5, t0.pu AS pu_6, t0.invoice_id AS invoice_id_7 FROM invoice_line t0 WHERE t0.invoice_id = 5 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.amount AS amount_3,
  t0.method AS method_4,
  t0.note AS note_5,
  t0.receipt_number AS receipt_number_6,
  t0.created_at AS created_at_7,
  t0.invoice_id AS invoice_id_8,
  t0.created_by_id AS created_by_id_9
FROM
  payment t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.date ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.method AS method_4, t0.note AS note_5, t0.receipt_number AS receipt_number_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8, t0.created_by_id AS created_by_id_9 FROM payment t0 WHERE t0.invoice_id = 4 ORDER BY t0.date ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.ref AS ref_3,
  t0.designation AS designation_4,
  t0.qte AS qte_5,
  t0.pu AS pu_6,
  t0.invoice_id AS invoice_id_7
FROM
  invoice_line t0
WHERE
  t0.invoice_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.ref AS ref_3, t0.designation AS designation_4, t0.qte AS qte_5, t0.pu AS pu_6, t0.invoice_id AS invoice_id_7 FROM invoice_line t0 WHERE t0.invoice_id = 4 ORDER BY t0.position ASC;