Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.is_verified AS is_verified_6,
  t0.auth_token AS auth_token_7,
  t0.salutation AS salutation_8,
  t0.first_name AS first_name_9,
  t0.last_name AS last_name_10,
  t0.created_by AS created_by_11,
  t0.updated_by AS updated_by_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_verified AS is_verified_6, t0.auth_token AS auth_token_7, t0.salutation AS salutation_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM user t0 WHERE t0.username = 'galab-api@galab.de' LIMIT 1;

SELECT
  o0_.article_number AS article_number_0,
  o0_.state AS state_1,
  o0_.state_updated_at AS state_updated_at_2,
  o0_.organic AS organic_3,
  o0_.estimated_completion_date AS estimated_completion_date_4,
  o0_.created_by AS created_by_5,
  o0_.updated_by AS updated_by_6,
  o0_.created_at AS created_at_7,
  o0_.updated_at AS updated_at_8,
  o0_.customer_order_number AS customer_order_number_9,
  o0_.name AS name_10,
  o0_.order_details AS order_details_11,
  o0_.customer_product_number AS customer_product_number_12,
  o0_.batch_number AS batch_number_13,
  o0_.best_before AS best_before_14,
  o0_.comment AS comment_15,
  o0_.delivery_date AS delivery_date_16,
  o0_.deleted_at AS deleted_at_17,
  o0_.auth_token AS auth_token_18,
  o0_.id AS id_19
FROM
  order_request o0_
WHERE
  o0_.deleted_at IS NULL
  AND o0_.state = ?
ORDER BY
  o0_.created_at DESC
LIMIT
  30

SELECT o0_.article_number AS article_number_0, o0_.state AS state_1, o0_.state_updated_at AS state_updated_at_2, o0_.organic AS organic_3, o0_.estimated_completion_date AS estimated_completion_date_4, o0_.created_by AS created_by_5, o0_.updated_by AS updated_by_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.customer_order_number AS customer_order_number_9, o0_.name AS name_10, o0_.order_details AS order_details_11, o0_.customer_product_number AS customer_product_number_12, o0_.batch_number AS batch_number_13, o0_.best_before AS best_before_14, o0_.comment AS comment_15, o0_.delivery_date AS delivery_date_16, o0_.deleted_at AS deleted_at_17, o0_.auth_token AS auth_token_18, o0_.id AS id_19 FROM order_request o0_ WHERE o0_.deleted_at IS NULL AND o0_.state = 'created' ORDER BY o0_.created_at DESC LIMIT 30;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_19
    FROM
      (
        SELECT
          o0_.article_number AS article_number_0,
          o0_.state AS state_1,
          o0_.state_updated_at AS state_updated_at_2,
          o0_.organic AS organic_3,
          o0_.estimated_completion_date AS estimated_completion_date_4,
          o0_.created_by AS created_by_5,
          o0_.updated_by AS updated_by_6,
          o0_.created_at AS created_at_7,
          o0_.updated_at AS updated_at_8,
          o0_.customer_order_number AS customer_order_number_9,
          o0_.name AS name_10,
          o0_.order_details AS order_details_11,
          o0_.customer_product_number AS customer_product_number_12,
          o0_.batch_number AS batch_number_13,
          o0_.best_before AS best_before_14,
          o0_.comment AS comment_15,
          o0_.delivery_date AS delivery_date_16,
          o0_.deleted_at AS deleted_at_17,
          o0_.auth_token AS auth_token_18,
          o0_.id AS id_19
        FROM
          order_request o0_
        WHERE
          o0_.deleted_at IS NULL
          AND o0_.state = ?
        ORDER BY
          o0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_19 FROM (SELECT o0_.article_number AS article_number_0, o0_.state AS state_1, o0_.state_updated_at AS state_updated_at_2, o0_.organic AS organic_3, o0_.estimated_completion_date AS estimated_completion_date_4, o0_.created_by AS created_by_5, o0_.updated_by AS updated_by_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.customer_order_number AS customer_order_number_9, o0_.name AS name_10, o0_.order_details AS order_details_11, o0_.customer_product_number AS customer_product_number_12, o0_.batch_number AS batch_number_13, o0_.best_before AS best_before_14, o0_.comment AS comment_15, o0_.delivery_date AS delivery_date_16, o0_.deleted_at AS deleted_at_17, o0_.auth_token AS auth_token_18, o0_.id AS id_19 FROM order_request o0_ WHERE o0_.deleted_at IS NULL AND o0_.state = 'created' ORDER BY o0_.created_at DESC) dctrn_result) dctrn_table;