Symfony Profiler

SELECT
  COUNT(s0_.id) AS sclr_0,
  COUNT(DISTINCT c1_.id) AS sclr_1,
  SUM(
    CASE WHEN s0_.gross_amount < 0 THEN
      1
    ELSE
      0
    END
  ) AS sclr_2,
  SUM(
    CASE WHEN s0_.mydata_error IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_3,
  COALESCE(
    SUM(
      CASE WHEN s0_.cancelled = 0 THEN
        s0_.net_amount
      ELSE
        0
      END
    ),
    0
  ) AS sclr_4,
  COALESCE(
    SUM(
      CASE WHEN s0_.cancelled = 0 THEN
        s0_.vat_amount
      ELSE
        0
      END
    ),
    0
  ) AS sclr_5,
  COALESCE(
    SUM(
      CASE WHEN s0_.cancelled = 0 THEN
        s0_.gross_amount
      ELSE
        0
      END
    ),
    0
  ) AS sclr_6
FROM
  sale s0_
  INNER JOIN customer c1_ ON s0_.customer_id = c1_.id

SELECT COUNT(s0_.id) AS sclr_0, COUNT(DISTINCT c1_.id) AS sclr_1, SUM(CASE WHEN s0_.gross_amount < 0 THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN s0_.mydata_error IS NOT NULL THEN 1 ELSE 0 END) AS sclr_3, COALESCE(SUM(CASE WHEN s0_.cancelled = 0 THEN s0_.net_amount ELSE 0 END), 0) AS sclr_4, COALESCE(SUM(CASE WHEN s0_.cancelled = 0 THEN s0_.vat_amount ELSE 0 END), 0) AS sclr_5, COALESCE(SUM(CASE WHEN s0_.cancelled = 0 THEN s0_.gross_amount ELSE 0 END), 0) AS sclr_6 FROM sale s0_ INNER JOIN customer c1_ ON s0_.customer_id = c1_.id;

SELECT
  s0_.id AS id_0,
  s0_.created_at AS created_at_1,
  s0_.document_number AS document_number_2,
  s0_.date AS date_3,
  s0_.gross_amount AS gross_amount_4,
  s0_.vat_amount AS vat_amount_5,
  s0_.expenses AS expenses_6,
  s0_.net_amount AS net_amount_7,
  s0_.payment_method AS payment_method_8,
  s0_.b2g AS b2g_9,
  s0_.cancelled AS cancelled_10,
  s0_.printed AS printed_11,
  s0_.conversion AS conversion_12,
  s0_.ship_to AS ship_to_13,
  s0_.ordered_by AS ordered_by_14,
  s0_.project AS project_15,
  s0_.status AS status_16,
  s0_.eshop AS eshop_17,
  s0_.mydata_type AS mydata_type_18,
  s0_.mydata_status AS mydata_status_19,
  s0_.mydata_mark AS mydata_mark_20,
  s0_.mydata_cancellation_mark AS mydata_cancellation_mark_21,
  s0_.mydata_uid AS mydata_uid_22,
  s0_.mydata_error AS mydata_error_23,
  s0_.mydata_qr_url AS mydata_qr_url_24,
  s0_.movement_status AS movement_status_25,
  s0_.movement_mark AS movement_mark_26,
  s0_.signature_url AS signature_url_27,
  s0_.digital_client_registry AS digital_client_registry_28,
  s0_.softone_created_at AS softone_created_at_29,
  s0_.softone_updated_at AS softone_updated_at_30,
  c1_.id AS id_31,
  c1_.name AS name_32,
  c1_.softone_code AS softone_code_33,
  c1_.vat_number AS vat_number_34,
  c1_.tax_office AS tax_office_35,
  c1_.profession AS profession_36,
  c1_.email AS email_37,
  c1_.phone AS phone_38,
  c1_.mobile AS mobile_39,
  c1_.address AS address_40,
  c1_.city AS city_41,
  c1_.postal_code AS postal_code_42,
  c1_.region AS region_43,
  c1_.balance AS balance_44,
  c1_.turnover AS turnover_45,
  c1_.category AS category_46,
  c1_.price_category AS price_category_47,
  c1_.discount AS discount_48,
  c1_.payment_method AS payment_method_49,
  c1_.vat_status AS vat_status_50,
  c1_.notes AS notes_51,
  c1_.active AS active_52,
  c1_.sms_marketing_consent AS sms_marketing_consent_53,
  c1_.sms_consent_changed_at AS sms_consent_changed_at_54,
  c1_.created_at AS created_at_55,
  c1_.updated_at AS updated_at_56,
  s0_.customer_id AS customer_id_57
FROM
  sale s0_
  INNER JOIN customer c1_ ON s0_.customer_id = c1_.id
ORDER BY
  s0_.date DESC,
  s0_.date DESC,
  s0_.document_number DESC,
  s0_.id DESC
LIMIT
  25

SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.document_number AS document_number_2, s0_.date AS date_3, s0_.gross_amount AS gross_amount_4, s0_.vat_amount AS vat_amount_5, s0_.expenses AS expenses_6, s0_.net_amount AS net_amount_7, s0_.payment_method AS payment_method_8, s0_.b2g AS b2g_9, s0_.cancelled AS cancelled_10, s0_.printed AS printed_11, s0_.conversion AS conversion_12, s0_.ship_to AS ship_to_13, s0_.ordered_by AS ordered_by_14, s0_.project AS project_15, s0_.status AS status_16, s0_.eshop AS eshop_17, s0_.mydata_type AS mydata_type_18, s0_.mydata_status AS mydata_status_19, s0_.mydata_mark AS mydata_mark_20, s0_.mydata_cancellation_mark AS mydata_cancellation_mark_21, s0_.mydata_uid AS mydata_uid_22, s0_.mydata_error AS mydata_error_23, s0_.mydata_qr_url AS mydata_qr_url_24, s0_.movement_status AS movement_status_25, s0_.movement_mark AS movement_mark_26, s0_.signature_url AS signature_url_27, s0_.digital_client_registry AS digital_client_registry_28, s0_.softone_created_at AS softone_created_at_29, s0_.softone_updated_at AS softone_updated_at_30, c1_.id AS id_31, c1_.name AS name_32, c1_.softone_code AS softone_code_33, c1_.vat_number AS vat_number_34, c1_.tax_office AS tax_office_35, c1_.profession AS profession_36, c1_.email AS email_37, c1_.phone AS phone_38, c1_.mobile AS mobile_39, c1_.address AS address_40, c1_.city AS city_41, c1_.postal_code AS postal_code_42, c1_.region AS region_43, c1_.balance AS balance_44, c1_.turnover AS turnover_45, c1_.category AS category_46, c1_.price_category AS price_category_47, c1_.discount AS discount_48, c1_.payment_method AS payment_method_49, c1_.vat_status AS vat_status_50, c1_.notes AS notes_51, c1_.active AS active_52, c1_.sms_marketing_consent AS sms_marketing_consent_53, c1_.sms_consent_changed_at AS sms_consent_changed_at_54, c1_.created_at AS created_at_55, c1_.updated_at AS updated_at_56, s0_.customer_id AS customer_id_57 FROM sale s0_ INNER JOIN customer c1_ ON s0_.customer_id = c1_.id ORDER BY s0_.date DESC, s0_.date DESC, s0_.document_number DESC, s0_.id DESC LIMIT 25;

SELECT
  s0_.mydata_type AS mydata_type_0,
  COUNT(s0_.id) AS sclr_1
FROM
  sale s0_
WHERE
  s0_.mydata_type IS NOT NULL
GROUP BY
  s0_.mydata_type
ORDER BY
  mydata_type_0 ASC

SELECT s0_.mydata_type AS mydata_type_0, COUNT(s0_.id) AS sclr_1 FROM sale s0_ WHERE s0_.mydata_type IS NOT NULL GROUP BY s0_.mydata_type ORDER BY mydata_type_0 ASC;

SELECT
  s0_.payment_method AS payment_method_0,
  COUNT(s0_.id) AS sclr_1
FROM
  sale s0_
WHERE
  s0_.payment_method IS NOT NULL
GROUP BY
  s0_.payment_method
ORDER BY
  payment_method_0 ASC

SELECT s0_.payment_method AS payment_method_0, COUNT(s0_.id) AS sclr_1 FROM sale s0_ WHERE s0_.payment_method IS NOT NULL GROUP BY s0_.payment_method ORDER BY payment_method_0 ASC;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 2;