Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  u0_.auth_permitted AS auth_permitted_3,
  u0_.phone AS phone_4,
  u0_.status AS status_5,
  u0_.reset_password_token AS reset_password_token_6,
  u0_.first_name AS first_name_7,
  u0_.last_name AS last_name_8,
  u0_.gender AS gender_9,
  u0_.birth_day AS birth_day_10,
  u0_.birth_place AS birth_place_11,
  u0_.department AS department_12,
  u0_.created_date AS created_date_13,
  u0_.updated_date AS updated_date_14,
  u0_.media_id AS media_id_15,
  u0_.country_id AS country_id_16,
  u0_.nationality_id AS nationality_id_17
FROM
  user u0_
WHERE
  u0_.email = ?
LIMIT
  1

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.auth_permitted AS auth_permitted_3, u0_.phone AS phone_4, u0_.status AS status_5, u0_.reset_password_token AS reset_password_token_6, u0_.first_name AS first_name_7, u0_.last_name AS last_name_8, u0_.gender AS gender_9, u0_.birth_day AS birth_day_10, u0_.birth_place AS birth_place_11, u0_.department AS department_12, u0_.created_date AS created_date_13, u0_.updated_date AS updated_date_14, u0_.media_id AS media_id_15, u0_.country_id AS country_id_16, u0_.nationality_id AS nationality_id_17 FROM user u0_ WHERE u0_.email = 'admin' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.name AS name_1,
          c0_.type AS type_2,
          c0_.ordering AS ordering_3
        FROM
          campaign c0_
        WHERE
          c0_.type = ?
        ORDER BY
          c0_.ordering ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.type AS type_2, c0_.ordering AS ordering_3 FROM campaign c0_ WHERE c0_.type = '1' ORDER BY c0_.ordering ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      ordering_3
    FROM
      (
        SELECT
          c0_.id AS id_0,
          c0_.name AS name_1,
          c0_.type AS type_2,
          c0_.ordering AS ordering_3
        FROM
          campaign c0_
        WHERE
          c0_.type = ?
      ) dctrn_result_inner
    ORDER BY
      ordering_3 ASC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, ordering_3 FROM (SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.type AS type_2, c0_.ordering AS ordering_3 FROM campaign c0_ WHERE c0_.type = '1') dctrn_result_inner ORDER BY ordering_3 ASC) dctrn_result LIMIT 50;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.display_name AS display_name_3,
  t0.is_base_role AS is_base_role_4,
  t0.ordering AS ordering_5
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.is_base_role AS is_base_role_4, t0.ordering AS ordering_5 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.type AS type_2,
  c0_.ordering AS ordering_3
FROM
  campaign c0_
WHERE
  c0_.type = ?
  AND c0_.id IN (?, ?, ?, ?, ?, ?, ?)
ORDER BY
  c0_.ordering ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.type AS type_2, c0_.ordering AS ordering_3 FROM campaign c0_ WHERE c0_.type = '1' AND c0_.id IN (1, 5, 6, 7, 8, 10, 11) ORDER BY c0_.ordering ASC;