Symfony Profiler

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  sales s0_
  LEFT JOIN products_sold p1_ ON s0_.id = p1_.sales_id
  LEFT JOIN user u2_ ON s0_.seller_id = u2_.id
  LEFT JOIN product p3_ ON p1_.product_id = p3_.id
  LEFT JOIN warehouse w4_ ON s0_.warehouse_id = w4_.id
  LEFT JOIN stock_info s5_ ON w4_.id = s5_.warehouse_id
  LEFT JOIN customer c6_ ON s0_.customer_id = c6_.id
WHERE
  s0_.visible = ?
  AND w4_.id = ?

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM sales s0_ LEFT JOIN products_sold p1_ ON s0_.id = p1_.sales_id LEFT JOIN user u2_ ON s0_.seller_id = u2_.id LEFT JOIN product p3_ ON p1_.product_id = p3_.id LEFT JOIN warehouse w4_ ON s0_.warehouse_id = w4_.id LEFT JOIN stock_info s5_ ON w4_.id = s5_.warehouse_id LEFT JOIN customer c6_ ON s0_.customer_id = c6_.id WHERE s0_.visible = 1 AND w4_.id = '7';

SELECT
  s0_.id AS id_0,
  s0_.invoice_number AS invoice_number_1,
  s0_.total_purchase_price AS total_purchase_price_2,
  s0_.sales_date AS sales_date_3,
  s0_.delivery_date AS delivery_date_4,
  s0_.due_date AS due_date_5,
  s0_.valid_date AS valid_date_6,
  s0_.description AS description_7,
  s0_.shipping_notes AS shipping_notes_8,
  s0_.payment_notes AS payment_notes_9,
  s0_.status AS status_10,
  s0_.visible AS visible_11,
  s0_.created_at AS created_at_12,
  s0_.updated_at AS updated_at_13,
  s0_.created_by AS created_by_14,
  s0_.updated_by AS updated_by_15,
  s0_.u_date AS u_date_16,
  s0_.seller_id AS seller_id_17,
  s0_.warehouse_id AS warehouse_id_18,
  s0_.customer_id AS customer_id_19,
  s0_.invoice_id AS invoice_id_20
FROM
  sales s0_
  LEFT JOIN products_sold p1_ ON s0_.id = p1_.sales_id
  LEFT JOIN user u2_ ON s0_.seller_id = u2_.id
  LEFT JOIN product p3_ ON p1_.product_id = p3_.id
  LEFT JOIN warehouse w4_ ON s0_.warehouse_id = w4_.id
  LEFT JOIN stock_info s5_ ON w4_.id = s5_.warehouse_id
  LEFT JOIN customer c6_ ON s0_.customer_id = c6_.id
WHERE
  s0_.visible = ?
  AND w4_.id = ?
  AND s0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.invoice_number AS invoice_number_1, s0_.total_purchase_price AS total_purchase_price_2, s0_.sales_date AS sales_date_3, s0_.delivery_date AS delivery_date_4, s0_.due_date AS due_date_5, s0_.valid_date AS valid_date_6, s0_.description AS description_7, s0_.shipping_notes AS shipping_notes_8, s0_.payment_notes AS payment_notes_9, s0_.status AS status_10, s0_.visible AS visible_11, s0_.created_at AS created_at_12, s0_.updated_at AS updated_at_13, s0_.created_by AS created_by_14, s0_.updated_by AS updated_by_15, s0_.u_date AS u_date_16, s0_.seller_id AS seller_id_17, s0_.warehouse_id AS warehouse_id_18, s0_.customer_id AS customer_id_19, s0_.invoice_id AS invoice_id_20 FROM sales s0_ LEFT JOIN products_sold p1_ ON s0_.id = p1_.sales_id LEFT JOIN user u2_ ON s0_.seller_id = u2_.id LEFT JOIN product p3_ ON p1_.product_id = p3_.id LEFT JOIN warehouse w4_ ON s0_.warehouse_id = w4_.id LEFT JOIN stock_info s5_ ON w4_.id = s5_.warehouse_id LEFT JOIN customer c6_ ON s0_.customer_id = c6_.id WHERE s0_.visible = 1 AND w4_.id = '7' AND s0_.id IN (1276, 1275, 1274, 1273, 1272, 1271, 1270, 1269, 1268, 1267, 1266, 1265, 1264, 1263, 1260, 1259, 1258, 1257, 1256, 1255, 1254, 1253, 1252, 1251, 1250) ORDER BY s0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.payment_date AS payment_date_2,
  t0.amount AS amount_3,
  t0.payment_status AS payment_status_4,
  t0.due_date AS due_date_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11,
  t0.customer_id AS customer_id_12,
  t0.payment_method_id AS payment_method_id_13,
  t0.sales_id AS sales_id_14,
  t0.invoice_id AS invoice_id_15,
  t0.sales_return_id AS sales_return_id_16
FROM
  payment t0
WHERE
  t0.sales_id = ?

SELECT t0.id AS id_1, t0.payment_date AS payment_date_2, t0.amount AS amount_3, t0.payment_status AS payment_status_4, t0.due_date AS due_date_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11, t0.customer_id AS customer_id_12, t0.payment_method_id AS payment_method_id_13, t0.sales_id AS sales_id_14, t0.invoice_id AS invoice_id_15, t0.sales_return_id AS sales_return_id_16 FROM payment t0 WHERE t0.sales_id = 1276;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.id AS id_1
FROM
  sales s0_
  LEFT JOIN products_sold p1_ ON s0_.id = p1_.sales_id
  LEFT JOIN user u2_ ON s0_.seller_id = u2_.id
  LEFT JOIN product p3_ ON p1_.product_id = p3_.id
  LEFT JOIN warehouse w4_ ON s0_.warehouse_id = w4_.id
  LEFT JOIN stock_info s5_ ON w4_.id = s5_.warehouse_id
  LEFT JOIN customer c6_ ON s0_.customer_id = c6_.id
WHERE
  s0_.visible = ?
  AND w4_.id = ?
ORDER BY
  s0_.id DESC
LIMIT
  25

SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM sales s0_ LEFT JOIN products_sold p1_ ON s0_.id = p1_.sales_id LEFT JOIN user u2_ ON s0_.seller_id = u2_.id LEFT JOIN product p3_ ON p1_.product_id = p3_.id LEFT JOIN warehouse w4_ ON s0_.warehouse_id = w4_.id LEFT JOIN stock_info s5_ ON w4_.id = s5_.warehouse_id LEFT JOIN customer c6_ ON s0_.customer_id = c6_.id WHERE s0_.visible = 1 AND w4_.id = '7' ORDER BY s0_.id DESC LIMIT 25;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.phone AS phone_3,
  t0.address AS address_4,
  t0.email AS email_5,
  t0.code AS code_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.u_date AS u_date_11
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.phone AS phone_3, t0.address AS address_4, t0.email AS email_5, t0.code AS code_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.u_date AS u_date_11 FROM customer t0 WHERE t0.id = 1450;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.locale AS locale_6,
  t0.username AS username_7,
  t0.fullname AS fullname_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.roles AS roles_4, t0.password AS password_5, t0.locale AS locale_6, t0.username AS username_7, t0.fullname AS fullname_8 FROM user t0 WHERE t0.id = 25;