Symfony Profiler

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 = 244 LIMIT 1;

SELECT
  ROUND(
    SUM(
      CASE WHEN m0_.mmp_source = 'tune' THEN
        m0_.total_payout
      ELSE
        CASE WHEN m0_.mmp_partner_rules_payout IS NOT NULL THEN
          (
            m0_.mmp_partner_rules_payout * m0_.event_count
          )
        ELSE
          (
            m0_.mmp_offer_default_payout * m0_.event_count
          )
        END
      END
    ),
    2
  ) AS sclr_0,
  ROUND(
    SUM(
      CASE WHEN m0_.mmp_source = 'tune' THEN
        m0_.total_revenue
      ELSE
        CASE WHEN m0_.mmp_partner_rules_revenue IS NOT NULL THEN
          (
            m0_.mmp_partner_rules_revenue * m0_.event_count
          )
        ELSE
          (
            m0_.mmp_offer_default_revenue * m0_.event_count
          )
        END
      END
    ),
    2
  ) AS sclr_1,
  DATE_FORMAT(m0_.report_date, '%Y-%m-%d') AS sclr_2,
  m0_.mmp_system_offer_id AS mmp_system_offer_id_3,
  m0_.mafo_offer_id AS mafo_offer_id_4,
  SUM(m0_.fraud_count) AS sclr_5,
  SUM(
    CASE WHEN m0_.mmp_partner_rules_payout IS NOT NULL THEN
      (
        m0_.mmp_partner_rules_payout * m0_.fraud_count
      )
    ELSE
      (
        m0_.mmp_offer_default_payout * m0_.fraud_count
      )
    END
  ) AS sclr_6,
  SUM(
    CASE WHEN m0_.mmp_partner_rules_revenue IS NOT NULL THEN
      (
        m0_.mmp_partner_rules_revenue * m0_.fraud_count
      )
    ELSE
      (
        m0_.mmp_offer_default_revenue * m0_.fraud_count
      )
    END
  ) AS sclr_7,
  SUM(
    m0_.event_count + CASE WHEN m0_.fraud_count IS NOT NULL THEN
      m0_.fraud_count
    ELSE
      0
    END
  ) AS sclr_8,
  m1_.name AS name_9,
  CASE WHEN m2_.system_identifier IN (
    'tune', 'tune_mobile', 'tune_web'
  ) THEN
    o3_.offer_type
  WHEN m2_.system_identifier IN ('adjust', 'appsflyer_agency') THEN
    m4_.offer_type
  ELSE
    ''
  END AS sclr_10
FROM
  mmp_reports m0_
  LEFT JOIN mafo_offers m1_ ON (m0_.mafo_offer_id = m1_.id)
  LEFT JOIN mafo_offers_mapping m2_ ON (m1_.id = m2_.mafo_offer)
  LEFT JOIN offer_info o3_ ON (
    m2_.system_identifier IN (
      'tune', 'tune_mobile', 'tune_web'
    )
    AND m2_.system_identifier_id = o3_.offer_id
  )
  LEFT JOIN mmp_offers m4_ ON (
    m2_.system_identifier IN ('adjust', 'appsflyer_agency')
    AND m2_.system_identifier_id = m4_.id
  )
WHERE
  m0_.report_timestamp >= ?
  AND m0_.report_timestamp <= ?
  AND (
    m0_.mmp_offer_id IS NULL
    OR m0_.mmp_offer_active_flag = 1
  )
  AND m0_.mmp_source <> 'appsflyer_agency_account_manager'
  AND m0_.mmp_source <> 'appsflyer_agency_af_agency'
  AND (
    m0_.mmp_source <> ?
    OR m0_.app_id NOT IN (
      SELECT
        m5_.mobile_app
      FROM
        mmp_offers m5_
      WHERE
        m5_.is_deleted = 0
    )
  )
  AND m0_.mmp_mobile_apps_id IS NOT NULL
  AND (
    m0_.affiliate NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
    OR m0_.is_from_appsflyer_blocked_capping = 1
  )
GROUP BY
  sclr_2,
  m0_.mafo_offer_id,
  m0_.mmp_system_offer_id,
  m1_.name,
  sclr_10

SELECT ROUND(SUM(CASE WHEN m0_.mmp_source = 'tune' THEN m0_.total_payout ELSE CASE WHEN m0_.mmp_partner_rules_payout IS NOT NULL THEN (m0_.mmp_partner_rules_payout * m0_.event_count) ELSE (m0_.mmp_offer_default_payout * m0_.event_count) END END), 2) AS sclr_0, ROUND(SUM(CASE WHEN m0_.mmp_source = 'tune' THEN m0_.total_revenue ELSE CASE WHEN m0_.mmp_partner_rules_revenue IS NOT NULL THEN (m0_.mmp_partner_rules_revenue * m0_.event_count) ELSE (m0_.mmp_offer_default_revenue * m0_.event_count) END END), 2) AS sclr_1, DATE_FORMAT(m0_.report_date, '%Y-%m-%d') AS sclr_2, m0_.mmp_system_offer_id AS mmp_system_offer_id_3, m0_.mafo_offer_id AS mafo_offer_id_4, SUM(m0_.fraud_count) AS sclr_5, SUM(CASE WHEN m0_.mmp_partner_rules_payout IS NOT NULL THEN (m0_.mmp_partner_rules_payout * m0_.fraud_count) ELSE (m0_.mmp_offer_default_payout * m0_.fraud_count) END) AS sclr_6, SUM(CASE WHEN m0_.mmp_partner_rules_revenue IS NOT NULL THEN (m0_.mmp_partner_rules_revenue * m0_.fraud_count) ELSE (m0_.mmp_offer_default_revenue * m0_.fraud_count) END) AS sclr_7, SUM(m0_.event_count + CASE WHEN m0_.fraud_count IS NOT NULL THEN m0_.fraud_count ELSE 0 END) AS sclr_8, m1_.name AS name_9, CASE WHEN m2_.system_identifier IN ('tune', 'tune_mobile', 'tune_web') THEN o3_.offer_type WHEN m2_.system_identifier IN ('adjust', 'appsflyer_agency') THEN m4_.offer_type ELSE '' END AS sclr_10 FROM mmp_reports m0_ LEFT JOIN mafo_offers m1_ ON (m0_.mafo_offer_id = m1_.id) LEFT JOIN mafo_offers_mapping m2_ ON (m1_.id = m2_.mafo_offer) LEFT JOIN offer_info o3_ ON (m2_.system_identifier IN ('tune', 'tune_mobile', 'tune_web') AND m2_.system_identifier_id = o3_.offer_id) LEFT JOIN mmp_offers m4_ ON (m2_.system_identifier IN ('adjust', 'appsflyer_agency') AND m2_.system_identifier_id = m4_.id) WHERE m0_.report_timestamp >= 1764547200 AND m0_.report_timestamp <= 1764547200 AND (m0_.mmp_offer_id IS NULL OR m0_.mmp_offer_active_flag = 1) AND m0_.mmp_source <> 'appsflyer_agency_account_manager' AND m0_.mmp_source <> 'appsflyer_agency_af_agency' AND (m0_.mmp_source <> 'tune' OR m0_.app_id NOT IN (SELECT m5_.mobile_app FROM mmp_offers m5_ WHERE m5_.is_deleted = 0)) AND m0_.mmp_mobile_apps_id IS NOT NULL AND (m0_.affiliate NOT IN ('Organic', 'unilead_int', 'webmedia_int', 'auradsp42_int', 'mobinovo52_int', 'traffic4yoil300', 'af-agencyil647', 'myappmediail647', 'mobuppsxil619') OR m0_.is_from_appsflyer_blocked_capping = 1) GROUP BY sclr_2, m0_.mafo_offer_id, m0_.mmp_system_offer_id, m1_.name, sclr_10;