Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.adresse AS adresse_3,
  t0.phone_number AS phone_number_4,
  t0.email AS email_5,
  t0.site_web AS site_web_6,
  t0.payment_terms AS payment_terms_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.status_supplier AS status_supplier_10,
  t0.logo AS logo_11,
  t0.country AS country_12,
  t0.city AS city_13,
  t0.archive_status AS archive_status_14,
  t0.point_of_sale_id AS point_of_sale_id_15,
  t0.field_of_activity_id AS field_of_activity_id_16
FROM
  supplier t0
WHERE
  t0.point_of_sale_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.adresse AS adresse_3, t0.phone_number AS phone_number_4, t0.email AS email_5, t0.site_web AS site_web_6, t0.payment_terms AS payment_terms_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.status_supplier AS status_supplier_10, t0.logo AS logo_11, t0.country AS country_12, t0.city AS city_13, t0.archive_status AS archive_status_14, t0.point_of_sale_id AS point_of_sale_id_15, t0.field_of_activity_id AS field_of_activity_id_16 FROM supplier t0 WHERE t0.point_of_sale_id = 35;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.quantity AS quantity_3,
  t0.purchase_price AS purchase_price_4,
  t0.bulk_price AS bulk_price_5,
  t0.retail_price AS retail_price_6,
  t0.manufacturing_date AS manufacturing_date_7,
  t0.expiration_date AS expiration_date_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.archive_status AS archive_status_11,
  t0.image AS image_12,
  t0.invoice_purchase AS invoice_purchase_13,
  t0.purchase_date AS purchase_date_14,
  t0.certificate_origin AS certificate_origin_15,
  t0.approval_certificate AS approval_certificate_16,
  t0.status_en_stock AS status_en_stock_17,
  t0.is_raw_material AS is_raw_material_18,
  t0.status AS status_19,
  t0.description AS description_20,
  t0.unit_of_measurement AS unit_of_measurement_21,
  t0.point_of_sale_id AS point_of_sale_id_22,
  t0.category_id AS category_id_23,
  t0.supplier_id AS supplier_id_24
FROM
  product t0
WHERE
  t0.point_of_sale_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.quantity AS quantity_3, t0.purchase_price AS purchase_price_4, t0.bulk_price AS bulk_price_5, t0.retail_price AS retail_price_6, t0.manufacturing_date AS manufacturing_date_7, t0.expiration_date AS expiration_date_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.archive_status AS archive_status_11, t0.image AS image_12, t0.invoice_purchase AS invoice_purchase_13, t0.purchase_date AS purchase_date_14, t0.certificate_origin AS certificate_origin_15, t0.approval_certificate AS approval_certificate_16, t0.status_en_stock AS status_en_stock_17, t0.is_raw_material AS is_raw_material_18, t0.status AS status_19, t0.description AS description_20, t0.unit_of_measurement AS unit_of_measurement_21, t0.point_of_sale_id AS point_of_sale_id_22, t0.category_id AS category_id_23, t0.supplier_id AS supplier_id_24 FROM product t0 WHERE t0.point_of_sale_id = 35;

SELECT
  t0.id AS id_1,
  t0.montant AS montant_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.ref AS ref_5,
  t0.payment_method AS payment_method_6,
  t0.type_reduction AS type_reduction_7,
  t0.amount_reduction AS amount_reduction_8,
  t0.total AS total_9,
  t0.point_of_sale_id AS point_of_sale_id_10,
  t0.discount_info AS discount_info_11,
  t0.customer_id AS customer_id_12,
  t0.user_id AS user_id_13,
  t0.session_sale_id AS session_sale_id_14
FROM
  sale t0
WHERE
  t0.point_of_sale_id = ?

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.ref AS ref_5, t0.payment_method AS payment_method_6, t0.type_reduction AS type_reduction_7, t0.amount_reduction AS amount_reduction_8, t0.total AS total_9, t0.point_of_sale_id AS point_of_sale_id_10, t0.discount_info AS discount_info_11, t0.customer_id AS customer_id_12, t0.user_id AS user_id_13, t0.session_sale_id AS session_sale_id_14 FROM sale t0 WHERE t0.point_of_sale_id = 35;

SELECT
  s0_.id AS id_0,
  s0_.montant AS montant_1,
  s0_.created_at AS created_at_2,
  s0_.updated_at AS updated_at_3,
  s0_.ref AS ref_4,
  s0_.payment_method AS payment_method_5,
  s0_.type_reduction AS type_reduction_6,
  s0_.amount_reduction AS amount_reduction_7,
  s0_.total AS total_8,
  s0_.point_of_sale_id AS point_of_sale_id_9,
  s0_.discount_info AS discount_info_10,
  s0_.customer_id AS customer_id_11,
  s0_.user_id AS user_id_12,
  s0_.session_sale_id AS session_sale_id_13
FROM
  sale s0_
WHERE
  (
    s0_.created_at >= ?
    AND s0_.created_at <= ?
  )
  AND s0_.point_of_sale_id = ?

SELECT s0_.id AS id_0, s0_.montant AS montant_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.ref AS ref_4, s0_.payment_method AS payment_method_5, s0_.type_reduction AS type_reduction_6, s0_.amount_reduction AS amount_reduction_7, s0_.total AS total_8, s0_.point_of_sale_id AS point_of_sale_id_9, s0_.discount_info AS discount_info_10, s0_.customer_id AS customer_id_11, s0_.user_id AS user_id_12, s0_.session_sale_id AS session_sale_id_13 FROM sale s0_ WHERE (s0_.created_at >= '2026-01-17 00:00:00' AND s0_.created_at <= '2026-01-18 00:00:00') AND s0_.point_of_sale_id = 35;

SELECT
  t0.id AS id_1,
  t0.last_name AS last_name_2,
  t0.first_name AS first_name_3,
  t0.adresse AS adresse_4,
  t0.phone_number AS phone_number_5,
  t0.email AS email_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.gender AS gender_9,
  t0.city AS city_10,
  t0.country AS country_11,
  t0.archive_status AS archive_status_12,
  t0.point_of_sale_id AS point_of_sale_id_13
FROM
  customer t0
WHERE
  t0.point_of_sale_id = ?

SELECT t0.id AS id_1, t0.last_name AS last_name_2, t0.first_name AS first_name_3, t0.adresse AS adresse_4, t0.phone_number AS phone_number_5, t0.email AS email_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.gender AS gender_9, t0.city AS city_10, t0.country AS country_11, t0.archive_status AS archive_status_12, t0.point_of_sale_id AS point_of_sale_id_13 FROM customer t0 WHERE t0.point_of_sale_id = 35;

SELECT
  t0.id AS id_1,
  t0.start AS start_2,
  t0.end AS end_3,
  t0.status AS status_4,
  t0.status_for_manager AS status_for_manager_5,
  t0.point_of_sale_id AS point_of_sale_id_6,
  t0.user_id AS user_id_7
FROM
  session_sale t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.status AS status_4, t0.status_for_manager AS status_for_manager_5, t0.point_of_sale_id AS point_of_sale_id_6, t0.user_id AS user_id_7 FROM session_sale t0 WHERE t0.user_id = 57;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.image AS image_7,
  t0.adresse AS adresse_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.archive_status AS archive_status_11,
  t0.is_email_received AS is_email_received_12,
  t0.is_sms_received AS is_sms_received_13,
  t0.point_of_sale_id AS point_of_sale_id_14
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.firstname AS firstname_5, t0.lastname AS lastname_6, t0.image AS image_7, t0.adresse AS adresse_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.archive_status AS archive_status_11, t0.is_email_received AS is_email_received_12, t0.is_sms_received AS is_sms_received_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM user t0 WHERE t0.id = 57;

SELECT
  CONCAT(' ', u0_.roles) AS sclr_0,
  COUNT(u0_.id) AS sclr_1
FROM
  user u0_
WHERE
  u0_.point_of_sale_id = ?
GROUP BY
  sclr_0

SELECT CONCAT(' ', u0_.roles) AS sclr_0, COUNT(u0_.id) AS sclr_1 FROM user u0_ WHERE u0_.point_of_sale_id = 35 GROUP BY sclr_0;

SELECT
  s0_.id AS id_0,
  s0_.montant AS montant_1,
  s0_.created_at AS created_at_2,
  s0_.updated_at AS updated_at_3,
  s0_.ref AS ref_4,
  s0_.payment_method AS payment_method_5,
  s0_.type_reduction AS type_reduction_6,
  s0_.amount_reduction AS amount_reduction_7,
  s0_.total AS total_8,
  s0_.point_of_sale_id AS point_of_sale_id_9,
  s0_.discount_info AS discount_info_10,
  s0_.customer_id AS customer_id_11,
  s0_.user_id AS user_id_12,
  s0_.session_sale_id AS session_sale_id_13
FROM
  sale s0_
WHERE
  MONTH(s0_.created_at) = MONTH(CURRENT_DATE)
  AND s0_.point_of_sale_id = ?

SELECT s0_.id AS id_0, s0_.montant AS montant_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.ref AS ref_4, s0_.payment_method AS payment_method_5, s0_.type_reduction AS type_reduction_6, s0_.amount_reduction AS amount_reduction_7, s0_.total AS total_8, s0_.point_of_sale_id AS point_of_sale_id_9, s0_.discount_info AS discount_info_10, s0_.customer_id AS customer_id_11, s0_.user_id AS user_id_12, s0_.session_sale_id AS session_sale_id_13 FROM sale s0_ WHERE MONTH(s0_.created_at) = MONTH(CURRENT_DATE) AND s0_.point_of_sale_id = 35;

SELECT
  MONTH(s0_.created_at) AS sclr_0,
  COUNT(s0_.id) AS sclr_1
FROM
  sale s0_
WHERE
  s0_.point_of_sale_id = ?
GROUP BY
  sclr_0

SELECT MONTH(s0_.created_at) AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM sale s0_ WHERE s0_.point_of_sale_id = 35 GROUP BY sclr_0;

SELECT
  c0_.gender AS gender_0,
  COUNT(c0_.id) AS sclr_1
FROM
  customer c0_
WHERE
  c0_.gender = ?
  OR c0_.gender = ?
GROUP BY
  c0_.gender

SELECT c0_.gender AS gender_0, COUNT(c0_.id) AS sclr_1 FROM customer c0_ WHERE c0_.gender = 'masculin' OR c0_.gender = 'feminin' GROUP BY c0_.gender;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.quantity AS quantity_3,
  t0.purchase_price AS purchase_price_4,
  t0.bulk_price AS bulk_price_5,
  t0.retail_price AS retail_price_6,
  t0.manufacturing_date AS manufacturing_date_7,
  t0.expiration_date AS expiration_date_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.archive_status AS archive_status_11,
  t0.image AS image_12,
  t0.invoice_purchase AS invoice_purchase_13,
  t0.purchase_date AS purchase_date_14,
  t0.certificate_origin AS certificate_origin_15,
  t0.approval_certificate AS approval_certificate_16,
  t0.status_en_stock AS status_en_stock_17,
  t0.is_raw_material AS is_raw_material_18,
  t0.status AS status_19,
  t0.description AS description_20,
  t0.unit_of_measurement AS unit_of_measurement_21,
  t0.point_of_sale_id AS point_of_sale_id_22,
  t0.category_id AS category_id_23,
  t0.supplier_id AS supplier_id_24
FROM
  product t0
WHERE
  t0.point_of_sale_id = ?
ORDER BY
  t0.id DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.name AS name_2, t0.quantity AS quantity_3, t0.purchase_price AS purchase_price_4, t0.bulk_price AS bulk_price_5, t0.retail_price AS retail_price_6, t0.manufacturing_date AS manufacturing_date_7, t0.expiration_date AS expiration_date_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.archive_status AS archive_status_11, t0.image AS image_12, t0.invoice_purchase AS invoice_purchase_13, t0.purchase_date AS purchase_date_14, t0.certificate_origin AS certificate_origin_15, t0.approval_certificate AS approval_certificate_16, t0.status_en_stock AS status_en_stock_17, t0.is_raw_material AS is_raw_material_18, t0.status AS status_19, t0.description AS description_20, t0.unit_of_measurement AS unit_of_measurement_21, t0.point_of_sale_id AS point_of_sale_id_22, t0.category_id AS category_id_23, t0.supplier_id AS supplier_id_24 FROM product t0 WHERE t0.point_of_sale_id = 35 ORDER BY t0.id DESC LIMIT 4;

SELECT
  s0_.id AS id_0,
  s0_.montant AS montant_1,
  s0_.created_at AS created_at_2,
  s0_.updated_at AS updated_at_3,
  s0_.ref AS ref_4,
  s0_.payment_method AS payment_method_5,
  s0_.type_reduction AS type_reduction_6,
  s0_.amount_reduction AS amount_reduction_7,
  s0_.total AS total_8,
  s0_.point_of_sale_id AS point_of_sale_id_9,
  s0_.discount_info AS discount_info_10,
  s0_.customer_id AS customer_id_11,
  s0_.user_id AS user_id_12,
  s0_.session_sale_id AS session_sale_id_13
FROM
  sale s0_
WHERE
  YEAR(s0_.created_at) = YEAR(CURRENT_DATE)
  AND s0_.point_of_sale_id = ?

SELECT s0_.id AS id_0, s0_.montant AS montant_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.ref AS ref_4, s0_.payment_method AS payment_method_5, s0_.type_reduction AS type_reduction_6, s0_.amount_reduction AS amount_reduction_7, s0_.total AS total_8, s0_.point_of_sale_id AS point_of_sale_id_9, s0_.discount_info AS discount_info_10, s0_.customer_id AS customer_id_11, s0_.user_id AS user_id_12, s0_.session_sale_id AS session_sale_id_13 FROM sale s0_ WHERE YEAR(s0_.created_at) = YEAR(CURRENT_DATE) AND s0_.point_of_sale_id = 35;