Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.softone_code AS softone_code_2,
  c0_.vat_number AS vat_number_3,
  c0_.tax_office AS tax_office_4,
  c0_.profession AS profession_5,
  c0_.email AS email_6,
  c0_.phone AS phone_7,
  c0_.mobile AS mobile_8,
  c0_.address AS address_9,
  c0_.city AS city_10,
  c0_.postal_code AS postal_code_11,
  c0_.region AS region_12,
  c0_.balance AS balance_13,
  c0_.turnover AS turnover_14,
  c0_.category AS category_15,
  c0_.price_category AS price_category_16,
  c0_.discount AS discount_17,
  c0_.payment_method AS payment_method_18,
  c0_.vat_status AS vat_status_19,
  c0_.notes AS notes_20,
  c0_.active AS active_21,
  c0_.sms_marketing_consent AS sms_marketing_consent_22,
  c0_.sms_consent_changed_at AS sms_consent_changed_at_23,
  c0_.created_at AS created_at_24,
  c0_.updated_at AS updated_at_25,
  CASE WHEN c0_.name IS NULL THEN
    1
  ELSE
    0
  END AS sclr_26
FROM
  customer c0_
ORDER BY
  sclr_26 ASC,
  c0_.name ASC,
  c0_.name ASC,
  c0_.id ASC
LIMIT
  25
OFFSET
  100

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.softone_code AS softone_code_2, c0_.vat_number AS vat_number_3, c0_.tax_office AS tax_office_4, c0_.profession AS profession_5, c0_.email AS email_6, c0_.phone AS phone_7, c0_.mobile AS mobile_8, c0_.address AS address_9, c0_.city AS city_10, c0_.postal_code AS postal_code_11, c0_.region AS region_12, c0_.balance AS balance_13, c0_.turnover AS turnover_14, c0_.category AS category_15, c0_.price_category AS price_category_16, c0_.discount AS discount_17, c0_.payment_method AS payment_method_18, c0_.vat_status AS vat_status_19, c0_.notes AS notes_20, c0_.active AS active_21, c0_.sms_marketing_consent AS sms_marketing_consent_22, c0_.sms_consent_changed_at AS sms_consent_changed_at_23, c0_.created_at AS created_at_24, c0_.updated_at AS updated_at_25, CASE WHEN c0_.name IS NULL THEN 1 ELSE 0 END AS sclr_26 FROM customer c0_ ORDER BY sclr_26 ASC, c0_.name ASC, c0_.name ASC, c0_.id ASC LIMIT 25 OFFSET 100;

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

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

SELECT
  COUNT(c0_.id) AS sclr_0,
  SUM(
    CASE WHEN c0_.active = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_1,
  COALESCE(
    SUM(c0_.turnover),
    0
  ) AS sclr_2,
  COALESCE(
    SUM(c0_.balance),
    0
  ) AS sclr_3,
  SUM(
    CASE WHEN c0_.balance <> 0 THEN
      1
    ELSE
      0
    END
  ) AS sclr_4,
  SUM(
    CASE WHEN c0_.sms_marketing_consent = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_5
FROM
  customer c0_

SELECT COUNT(c0_.id) AS sclr_0, SUM(CASE WHEN c0_.active = 1 THEN 1 ELSE 0 END) AS sclr_1, COALESCE(SUM(c0_.turnover), 0) AS sclr_2, COALESCE(SUM(c0_.balance), 0) AS sclr_3, SUM(CASE WHEN c0_.balance <> 0 THEN 1 ELSE 0 END) AS sclr_4, SUM(CASE WHEN c0_.sms_marketing_consent = 1 THEN 1 ELSE 0 END) AS sclr_5 FROM customer c0_;

SELECT
  c0_.category AS category_0,
  COUNT(c0_.id) AS sclr_1
FROM
  customer c0_
WHERE
  c0_.category IS NOT NULL
GROUP BY
  c0_.category
ORDER BY
  category_0 ASC

SELECT c0_.category AS category_0, COUNT(c0_.id) AS sclr_1 FROM customer c0_ WHERE c0_.category IS NOT NULL GROUP BY c0_.category ORDER BY category_0 ASC;

SELECT
  c0_.city AS city_0,
  COUNT(c0_.id) AS sclr_1
FROM
  customer c0_
WHERE
  c0_.city IS NOT NULL
GROUP BY
  c0_.city
ORDER BY
  city_0 ASC

SELECT c0_.city AS city_0, COUNT(c0_.id) AS sclr_1 FROM customer c0_ WHERE c0_.city IS NOT NULL GROUP BY c0_.city ORDER BY city_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;