Symfony Profiler

SELECT
  CASE WHEN a0_.platform IS NOT NULL THEN
    a0_.platform
  ELSE
    m1_.platform
  END AS sclr_0,
  ROUND(
    SUM(
      CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web') THEN
        m2_.total_payout
      ELSE
        CASE WHEN m2_.mmp_partner_rules_payout IS NOT NULL THEN
          (
            m2_.mmp_partner_rules_payout * m2_.event_count
          )
        ELSE
          (
            m2_.mmp_offer_default_payout * m2_.event_count
          )
        END
      END
    ),
    2
  ) AS sclr_1,
  ROUND(
    SUM(
      CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web') THEN
        m2_.total_revenue
      ELSE
        CASE WHEN m2_.mmp_partner_rules_revenue IS NOT NULL THEN
          (
            m2_.mmp_partner_rules_revenue * m2_.event_count
          )
        ELSE
          (
            m2_.mmp_offer_default_revenue * m2_.event_count
          )
        END
      END
    ),
    2
  ) AS sclr_2,
  SUM(
    CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web') THEN
      (
        CASE WHEN m2_.mmp_offer_default_revenue_event_name = 'install' THEN
          (
            CASE WHEN m3_.clicks IS NOT NULL THEN
              m3_.clicks
            ELSE
              m2_.clicks
            END
          )
        ELSE
          0
        END
      )
    ELSE
      (
        CASE WHEN m2_.event IN (
          'install', 're-attribution', 're-engagement'
        ) THEN
          (
            CASE WHEN m3_.clicks IS NOT NULL THEN
              m3_.clicks
            ELSE
              m2_.clicks
            END
          )
        ELSE
          0
        END
      )
    END
  ) AS sclr_3,
  SUM(
    CASE WHEN m2_.event = 'install'
    OR m2_.event = '0' THEN
      (
        CASE WHEN m3_.impressions IS NOT NULL THEN
          m3_.impressions
        ELSE
          m2_.impressions
        END
      )
    ELSE
      0
    END
  ) AS sclr_4,
  ROUND(
    SUM(
      CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web')
      OR m2_.event <> 'install' THEN
        0
      ELSE
        m2_.clicks
      END
    ) / SUM(
      CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web')
      OR m2_.event <> 'install' THEN
        0
      ELSE
        m2_.impressions
      END
    ),
    4
  ) AS sclr_5,
  ROUND(
    SUM(
      CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web')
      OR m2_.event <> 'install' THEN
        0
      ELSE
        (
          CASE WHEN m3_.event_count IS NOT NULL THEN
            m3_.event_count
          ELSE
            m2_.event_count
          END
        )
      END
    ) / SUM(
      CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web')
      OR m2_.event <> 'install' THEN
        0
      ELSE
        (
          CASE WHEN m3_.clicks IS NOT NULL THEN
            m3_.clicks
          ELSE
            m2_.clicks
          END
        )
      END
    ),
    4
  ) AS sclr_6,
  m2_.mmp_source AS mmp_source_7,
  m2_.geo AS geo_8,
  m2_.mafo_advertiser_id AS mafo_advertiser_id_9,
  m2_.mafo_affiliate_id AS mafo_affiliate_id_10,
  m2_.mafo_offer_id AS mafo_offer_id_11,
  m4_.name AS name_12,
  SUM(m2_.fraud_count) AS sclr_13,
  SUM(
    CASE WHEN m2_.mmp_partner_rules_payout IS NOT NULL THEN
      (
        m2_.mmp_partner_rules_payout * m2_.fraud_count
      )
    ELSE
      (
        m2_.mmp_offer_default_payout * m2_.fraud_count
      )
    END
  ) AS sclr_14,
  SUM(
    CASE WHEN m2_.mmp_partner_rules_revenue IS NOT NULL THEN
      (
        m2_.mmp_partner_rules_revenue * m2_.fraud_count
      )
    ELSE
      (
        m2_.mmp_offer_default_revenue * m2_.fraud_count
      )
    END
  ) AS sclr_15,
  SUM(
    CASE WHEN m3_.event_count IS NOT NULL THEN
      m3_.event_count + (
        CASE WHEN m2_.fraud_count IS NOT NULL
        AND m3_.affiliate = m2_.affiliate THEN
          m2_.fraud_count
        ELSE
          0
        END
      )
    ELSE
      m2_.event_count + (
        CASE WHEN m2_.fraud_count IS NOT NULL THEN
          m2_.fraud_count
        ELSE
          0
        END
      )
    END
  ) AS sclr_16,
  CONCAT(c5_.name, '(', c5_.alpha2, ')') AS sclr_17,
  m6_.name AS name_18,
  m7_.name AS name_19
FROM
  mmp_reports m2_
  LEFT JOIN agg_pid_ui_view a8_ ON (m2_.id = a8_.global_reports_id)
  LEFT JOIN mafo_offers m6_ ON (m2_.mafo_offer_id = m6_.id)
  LEFT JOIN mafo_advertisers m7_ ON (m2_.mafo_advertiser_id = m7_.id)
  LEFT JOIN countries c5_ ON (m2_.geo = c5_.alpha2)
  LEFT JOIN mafo_affiliates m4_ ON (m4_.id = m2_.mafo_affiliate_id)
  LEFT JOIN app_info a0_ ON (m2_.app_id = a0_.app_id)
  LEFT JOIN mmp_mobile_apps m1_ ON (
    m2_.app_id = m1_.bundle_id
    AND m2_.mmp_source = m1_.tracking_system
    AND m2_.os = m1_.platform
  )
  LEFT JOIN mmp_dummy_reports m3_ ON (m2_.id = m3_.mmp_reports_id)
WHERE
  m2_.report_timestamp >= ?
  AND m2_.report_timestamp <= ?
  AND (
    m2_.mmp_offer_id IS NULL
    OR m2_.mmp_offer_active_flag = 1
  )
  AND (
    m2_.mmp_source NOT IN (?, ?)
    OR m2_.app_id NOT IN (
      SELECT
        m9_.mobile_app
      FROM
        mmp_offers m9_
      WHERE
        m9_.is_deleted = 0
    )
  )
  AND m2_.mmp_mobile_apps_id IS NOT NULL
  AND (
    m2_.affiliate NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
    OR m2_.is_from_appsflyer_blocked_capping = 1
  )
GROUP BY
  m2_.mafo_offer_id,
  m6_.name,
  m2_.mafo_advertiser_id,
  m7_.name,
  m2_.mafo_affiliate_id,
  m4_.name,
  sclr_0,
  sclr_17,
  m2_.geo,
  m2_.mmp_source

SELECT CASE WHEN a0_.platform IS NOT NULL THEN a0_.platform ELSE m1_.platform END AS sclr_0, ROUND(SUM(CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web') THEN m2_.total_payout ELSE CASE WHEN m2_.mmp_partner_rules_payout IS NOT NULL THEN (m2_.mmp_partner_rules_payout * m2_.event_count) ELSE (m2_.mmp_offer_default_payout * m2_.event_count) END END), 2) AS sclr_1, ROUND(SUM(CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web') THEN m2_.total_revenue ELSE CASE WHEN m2_.mmp_partner_rules_revenue IS NOT NULL THEN (m2_.mmp_partner_rules_revenue * m2_.event_count) ELSE (m2_.mmp_offer_default_revenue * m2_.event_count) END END), 2) AS sclr_2, SUM(CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web') THEN (CASE WHEN m2_.mmp_offer_default_revenue_event_name = 'install' THEN (CASE WHEN m3_.clicks IS NOT NULL THEN m3_.clicks ELSE m2_.clicks END) ELSE 0 END) ELSE (CASE WHEN m2_.event IN ('install', 're-attribution', 're-engagement') THEN (CASE WHEN m3_.clicks IS NOT NULL THEN m3_.clicks ELSE m2_.clicks END) ELSE 0 END) END) AS sclr_3, SUM(CASE WHEN m2_.event = 'install' OR m2_.event = '0' THEN (CASE WHEN m3_.impressions IS NOT NULL THEN m3_.impressions ELSE m2_.impressions END) ELSE 0 END) AS sclr_4, ROUND(SUM(CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web') OR m2_.event <> 'install' THEN 0 ELSE m2_.clicks END) / SUM(CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web') OR m2_.event <> 'install' THEN 0 ELSE m2_.impressions END), 4) AS sclr_5, ROUND(SUM(CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web') OR m2_.event <> 'install' THEN 0 ELSE (CASE WHEN m3_.event_count IS NOT NULL THEN m3_.event_count ELSE m2_.event_count END) END) / SUM(CASE WHEN m2_.mmp_source IN ('tune_mobile', 'tune_web') OR m2_.event <> 'install' THEN 0 ELSE (CASE WHEN m3_.clicks IS NOT NULL THEN m3_.clicks ELSE m2_.clicks END) END), 4) AS sclr_6, m2_.mmp_source AS mmp_source_7, m2_.geo AS geo_8, m2_.mafo_advertiser_id AS mafo_advertiser_id_9, m2_.mafo_affiliate_id AS mafo_affiliate_id_10, m2_.mafo_offer_id AS mafo_offer_id_11, m4_.name AS name_12, SUM(m2_.fraud_count) AS sclr_13, SUM(CASE WHEN m2_.mmp_partner_rules_payout IS NOT NULL THEN (m2_.mmp_partner_rules_payout * m2_.fraud_count) ELSE (m2_.mmp_offer_default_payout * m2_.fraud_count) END) AS sclr_14, SUM(CASE WHEN m2_.mmp_partner_rules_revenue IS NOT NULL THEN (m2_.mmp_partner_rules_revenue * m2_.fraud_count) ELSE (m2_.mmp_offer_default_revenue * m2_.fraud_count) END) AS sclr_15, SUM(CASE WHEN m3_.event_count IS NOT NULL THEN m3_.event_count + (CASE WHEN m2_.fraud_count IS NOT NULL AND m3_.affiliate = m2_.affiliate THEN m2_.fraud_count ELSE 0 END) ELSE m2_.event_count + (CASE WHEN m2_.fraud_count IS NOT NULL THEN m2_.fraud_count ELSE 0 END) END) AS sclr_16, CONCAT(c5_.name, '(', c5_.alpha2, ')') AS sclr_17, m6_.name AS name_18, m7_.name AS name_19 FROM mmp_reports m2_ LEFT JOIN agg_pid_ui_view a8_ ON (m2_.id = a8_.global_reports_id) LEFT JOIN mafo_offers m6_ ON (m2_.mafo_offer_id = m6_.id) LEFT JOIN mafo_advertisers m7_ ON (m2_.mafo_advertiser_id = m7_.id) LEFT JOIN countries c5_ ON (m2_.geo = c5_.alpha2) LEFT JOIN mafo_affiliates m4_ ON (m4_.id = m2_.mafo_affiliate_id) LEFT JOIN app_info a0_ ON (m2_.app_id = a0_.app_id) LEFT JOIN mmp_mobile_apps m1_ ON (m2_.app_id = m1_.bundle_id AND m2_.mmp_source = m1_.tracking_system AND m2_.os = m1_.platform) LEFT JOIN mmp_dummy_reports m3_ ON (m2_.id = m3_.mmp_reports_id) WHERE m2_.report_timestamp >= 1774483200 AND m2_.report_timestamp <= 1774483200 AND (m2_.mmp_offer_id IS NULL OR m2_.mmp_offer_active_flag = 1) AND (m2_.mmp_source NOT IN ('tune_mobile', 'tune_web') OR m2_.app_id NOT IN (SELECT m9_.mobile_app FROM mmp_offers m9_ WHERE m9_.is_deleted = 0)) AND m2_.mmp_mobile_apps_id IS NOT NULL AND (m2_.affiliate NOT IN ('Organic', 'unilead_int', 'webmedia_int', 'auradsp42_int', 'mobinovo52_int', 'traffic4yoil300', 'af-agencyil647', 'myappmediail647', 'mobuppsxil619') OR m2_.is_from_appsflyer_blocked_capping = 1) GROUP BY m2_.mafo_offer_id, m6_.name, m2_.mafo_advertiser_id, m7_.name, m2_.mafo_affiliate_id, m4_.name, sclr_0, sclr_17, m2_.geo, m2_.mmp_source;

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