Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.account_manager_email AS account_manager_email_2,
  u1_.name AS name_3,
  m0_.sales_manager_email AS sales_manager_email_4,
  u2_.name AS name_5,
  m0_.updated_by_email AS updated_by_email_6,
  m0_.status AS status_7,
  m0_.date_inserted AS date_inserted_8,
  m0_.date_updated AS date_updated_9,
  GROUP_CONCAT(
    CONCAT(
      m3_.system_identifier, ':', m3_.system_identifier_id,
      ':', CASE WHEN m3_.system_identifier = 'tune_mobile' THEN
        a4_.company
      ELSE
        CASE WHEN m3_.system_identifier = 'tune_web' THEN
          a5_.company
        ELSE
          ''
        END
      END
    ) SEPARATOR '|'
  ) AS sclr_10
FROM
  mafo_advertisers m0_
  LEFT JOIN mafo_advertisers_mapping m3_ ON (
    m0_.id = m3_.mafo_advertiser_id
    AND m3_.deletedAt IS NULL
  )
  LEFT JOIN users u1_ ON (
    u1_.email = m0_.account_manager_email
  )
  LEFT JOIN users u2_ ON (
    u2_.email = m0_.sales_manager_email
  )
  LEFT JOIN advertiser_info a4_ ON (
    a4_.advertiser_id = m3_.system_identifier_id
    AND a4_.tune_account = m3_.system_identifier
  )
  LEFT JOIN advertiser_info a5_ ON (
    a5_.advertiser_id = m3_.system_identifier_id
    AND a5_.tune_account = m3_.system_identifier
  )
GROUP BY
  m0_.id
ORDER BY
  m0_.id DESC
LIMIT
  1000000

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.account_manager_email AS account_manager_email_2, u1_.name AS name_3, m0_.sales_manager_email AS sales_manager_email_4, u2_.name AS name_5, m0_.updated_by_email AS updated_by_email_6, m0_.status AS status_7, m0_.date_inserted AS date_inserted_8, m0_.date_updated AS date_updated_9, GROUP_CONCAT(CONCAT(m3_.system_identifier, ':', m3_.system_identifier_id, ':', CASE WHEN m3_.system_identifier = 'tune_mobile' THEN a4_.company ELSE CASE WHEN m3_.system_identifier = 'tune_web' THEN a5_.company ELSE '' END END) SEPARATOR '|') AS sclr_10 FROM mafo_advertisers m0_ LEFT JOIN mafo_advertisers_mapping m3_ ON (m0_.id = m3_.mafo_advertiser_id AND m3_.deletedAt IS NULL) LEFT JOIN users u1_ ON (u1_.email = m0_.account_manager_email) LEFT JOIN users u2_ ON (u2_.email = m0_.sales_manager_email) LEFT JOIN advertiser_info a4_ ON (a4_.advertiser_id = m3_.system_identifier_id AND a4_.tune_account = m3_.system_identifier) LEFT JOIN advertiser_info a5_ ON (a5_.advertiser_id = m3_.system_identifier_id AND a5_.tune_account = m3_.system_identifier) GROUP BY m0_.id ORDER BY m0_.id DESC LIMIT 1000000;

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12,
  t0.google_id AS google_id_13,
  t0.mts_id AS mts_id_14,
  t0.pingboard_id AS pingboard_id_15,
  t0.reports_to_id AS reports_to_id_16,
  t0.google_access_token AS google_access_token_17,
  t0.jwt_token AS jwt_token_18,
  t0.mts_access_token AS mts_access_token_19,
  t0.picture AS picture_20,
  t0.name AS name_21,
  t0.first_name AS first_name_22,
  t0.last_name AS last_name_23,
  t0.position AS position_24,
  t0.user_info AS user_info_25,
  t0.login_type AS login_type_26,
  t0.team_id AS team_id_27,
  t0.whitelisted_ips AS whitelisted_ips_28,
  t0.status AS status_29
FROM
  users t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.google_id AS google_id_13, t0.mts_id AS mts_id_14, t0.pingboard_id AS pingboard_id_15, t0.reports_to_id AS reports_to_id_16, t0.google_access_token AS google_access_token_17, t0.jwt_token AS jwt_token_18, t0.mts_access_token AS mts_access_token_19, t0.picture AS picture_20, t0.name AS name_21, t0.first_name AS first_name_22, t0.last_name AS last_name_23, t0.position AS position_24, t0.user_info AS user_info_25, t0.login_type AS login_type_26, t0.team_id AS team_id_27, t0.whitelisted_ips AS whitelisted_ips_28, t0.status AS status_29 FROM users t0 WHERE t0.id = 25 LIMIT 1;