Symfony Profiler

[
  "route" => "api_chartscorrelation_stats"
  "route_parameters" => [
    "_route" => "api_chartscorrelation_stats"
    "_controller" => "App\Controller\ChartController::getCorrelationStatsAction"
  ]
  "request_uri" => "https://mafo-test.mobupps.com/api/chart/correlation-stats?category=affiliate_id&dateEnd=Thu%20Mar%2026%202026&dateStart=Thu%20Mar%2026%202026&limit=10&pullFromCache=1&sortBy=revenue&type=ctr"
  "method" => "GET"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "mafo-rds-test.c4mpaevtj7ue.us-east-2.rds.amazonaws.com"
    "port" => 3306
    "user" => "admin"
    "password" => "<redacted>"
    "driverOptions" => [
      1001 => true
      1002 => "SET sql_mode=(SELECT REPLACE(@@sql_mode, "ONLY_FULL_GROUP_BY", ""))"
    ]
    "serverVersion" => "8"
    "defaultTableOptions" => []
    "dbname" => "mobupps_test_clone"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 448
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "FOS\UserBundle\Security\EmailUserProvider"
  "username" => "112499271597072897518"
]

[
  "firewall_name" => "main"
  "authenticators" => 3
]

[
  "firewall_name" => "main"
  "authenticator" => "HWI\Bundle\OAuthBundle\Security\Http\Authenticator\OAuthAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "HWI\Bundle\OAuthBundle\Security\Http\Authenticator\OAuthAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\FormLoginAuthenticator"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Http\HttplugBundle\Discovery\ConfiguredClientsStrategyListener::onEvent"
]

[
  "event" => "kernel.request"
  "listener" => "Http\HttplugBundle\Collector\PluginClientFactoryListener::onEvent"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\InvalidApiPathListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Sentry\SentryBundle\EventListener\RequestListener::handleKernelRequestEvent"
]

[
  "event" => "kernel.request"
  "listener" => "Sentry\SentryBundle\EventListener\TracingRequestListener::handleKernelRequestEvent"
]

[
  "event" => "kernel.request"
  "listener" => "Sentry\SentryBundle\EventListener\SubRequestListener::handleKernelRequestEvent"
]

[
  "event" => "kernel.request"
  "listener" => "Sentry\SentryBundle\EventListener\TracingSubRequestListener::handleKernelRequestEvent"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\CsvSanitizerListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\RequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Sentry\SentryBundle\EventListener\LoginListener::handleKernelRequestEvent"
]

[
  "event" => "kernel.controller"
  "listener" => "Sentry\SentryBundle\EventListener\RequestListener::handleKernelControllerEvent"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "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"
  "params" => [
    1 => 1774483200
    2 => 1774483200
    3 => "tune_mobile"
    4 => "tune_web"
    5 => "Organic"
    6 => "unilead_int"
    7 => "webmedia_int"
    8 => "auradsp42_int"
    9 => "mobinovo52_int"
    10 => "traffic4yoil300"
    11 => "af-agencyil647"
    12 => "myappmediail647"
    13 => "mobuppsxil619"
  ]
  "types" => [
    1 => 1
    2 => 1
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Sentry\SentryBundle\EventListener\TracingRequestListener::handleKernelResponseEvent"
]

[
  "event" => "kernel.response"
  "listener" => "Sentry\SentryBundle\EventListener\TracingSubRequestListener::handleKernelResponseEvent"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Mercure\EventSubscriber\SetCookieSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Sentry\SentryBundle\EventListener\TracingSubRequestListener::handleKernelFinishRequestEvent"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Sentry\SentryBundle\EventListener\SubRequestListener::handleKernelFinishRequestEvent"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]