Symfony Profiler

[
  "route" => "app_operator_dashboard_period_metrics"
  "route_parameters" => [
    "_route" => "app_operator_dashboard_period_metrics"
    "_controller" => "App\Operator\Controller\GetDashboardPeriodMetricsController"
  ]
  "request_uri" => "https://operators.la-demo.com/operator/dashboard/period-metrics?campaigns=1&content_type=all&end=2026-08-04&start=2026-07-26"
  "method" => "GET"
]

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

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

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

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "mysql"
    "port" => 3306
    "user" => "creatorshub"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "creatorshub"
    "serverVersion" => "8.4"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.country AS country_4, t0.language AS language_5, t0.roles AS roles_6, t0.password AS password_7, t0.enabled AS enabled_8, t0.image AS image_9, t0.beatandeal_tipster_id AS beatandeal_tipster_id_10, t0.beatandeal_operator_ids AS beatandeal_operator_ids_11, t0.created_at AS created_at_12 FROM `user` t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "jespinosa@betandeal.com"
]

[
  "sql" => "SELECT c0_.metric_date AS metric_date_0, COALESCE(SUM(c0_.metric_posts), 0) AS sclr_1, COALESCE(SUM(c0_.metric_reach), 0) AS sclr_2, COALESCE(SUM(c0_.metric_impressions), 0) AS sclr_3, COALESCE(SUM(c0_.metric_likes), 0) AS sclr_4, COALESCE(SUM(c0_.metric_comments), 0) AS sclr_5 FROM content_metrics_history c0_ INNER JOIN creator_social_content c1_ ON c0_.content_id = c1_.id INNER JOIN creator_content_campaign c2_ ON (c2_.content_id = c1_.id) INNER JOIN creator_campaign c3_ ON c2_.campaign_id = c3_.id WHERE c3_.operator_id = ? AND (c0_.metric_date BETWEEN ? AND ?) AND c3_.id IN (?) GROUP BY c0_.metric_date ORDER BY c0_.metric_date ASC"
  "params" => [
    1 => 2
    2 => "2026-07-26 00:00:00"
    3 => "2026-08-04 00:00:00"
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#923
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#923}
    4 => Doctrine\DBAL\ParameterType {#906}
  ]
]

[
  "sql" => "SELECT c0_.metric_date AS metric_date_0, COALESCE(SUM(c0_.metric_clicks), 0) AS sclr_1, COALESCE(SUM(c0_.metric_ftds), 0) AS sclr_2, COALESCE(SUM(c0_.metric_cpa), 0) AS sclr_3 FROM campaign_metrics_history c0_ INNER JOIN creator_campaign c1_ ON c0_.campaign_id = c1_.id WHERE c1_.operator_id = ? AND (c0_.metric_date BETWEEN ? AND ?) AND c1_.id IN (?) GROUP BY c0_.metric_date ORDER BY c0_.metric_date ASC"
  "params" => [
    1 => 2
    2 => "2026-07-26 00:00:00"
    3 => "2026-08-04 00:00:00"
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#923
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#923}
    4 => Doctrine\DBAL\ParameterType {#906}
  ]
]

[
  "sql" => "SELECT c0_.type AS type_0, COALESCE(SUM(c1_.metric_posts), 0) AS sclr_1 FROM content_metrics_history c1_ INNER JOIN creator_social_content c0_ ON c1_.content_id = c0_.id INNER JOIN creator_content_campaign c2_ ON (c2_.content_id = c0_.id) INNER JOIN creator_campaign c3_ ON c2_.campaign_id = c3_.id WHERE c3_.operator_id = ? AND c1_.metric_date = ? AND c3_.id IN (?) GROUP BY c0_.type"
  "params" => [
    1 => 2
    2 => "2026-08-04 00:00:00"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#923
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#906}
  ]
]

[
  "sql" => "SELECT DISTINCT c0_.id AS id_0 FROM content_metrics_history c1_ INNER JOIN creator_social_content c2_ ON c1_.content_id = c2_.id INNER JOIN creator_content_campaign c3_ ON (c3_.content_id = c2_.id) INNER JOIN creator_campaign c0_ ON c3_.campaign_id = c0_.id WHERE c0_.operator_id = ? AND (c1_.metric_date BETWEEN ? AND ?) AND c0_.id IN (?)"
  "params" => [
    1 => 2
    2 => "2026-07-26 00:00:00"
    3 => "2026-08-04 00:00:00"
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#923
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#923}
    4 => Doctrine\DBAL\ParameterType {#906}
  ]
]

[
  "sql" => "SELECT DISTINCT c0_.id AS id_0 FROM campaign_metrics_history c1_ INNER JOIN creator_campaign c0_ ON c1_.campaign_id = c0_.id WHERE c0_.operator_id = ? AND (c1_.metric_date BETWEEN ? AND ?) AND c0_.id IN (?)"
  "params" => [
    1 => 2
    2 => "2026-07-26 00:00:00"
    3 => "2026-08-04 00:00:00"
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#923
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#923}
    4 => Doctrine\DBAL\ParameterType {#906}
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(c0_.target_reach), 0) AS sclr_0, COALESCE(SUM(c0_.target_impressions), 0) AS sclr_1, COALESCE(SUM(c0_.target_likes), 0) AS sclr_2, COALESCE(SUM(c0_.target_comments), 0) AS sclr_3, COALESCE(SUM(c0_.target_clicks), 0) AS sclr_4, COALESCE(SUM(c0_.target_ftds), 0) AS sclr_5, COALESCE(SUM(c0_.target_cpa), 0) AS sclr_6 FROM creator_campaign c0_ WHERE c0_.id IN (?)"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(c0_.target_reach), 0) AS sclr_0, COALESCE(SUM(c0_.target_impressions), 0) AS sclr_1, COALESCE(SUM(c0_.target_likes), 0) AS sclr_2, COALESCE(SUM(c0_.target_comments), 0) AS sclr_3, COALESCE(SUM(c0_.target_clicks), 0) AS sclr_4, COALESCE(SUM(c0_.target_ftds), 0) AS sclr_5, COALESCE(SUM(c0_.target_cpa), 0) AS sclr_6 FROM creator_campaign c0_ WHERE c0_.id IN (?)"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COALESCE(SUM(c0_.expected_contents), 0) AS sclr_0 FROM creator_campaign_tipster c0_ INNER JOIN creator_campaign c1_ ON c0_.campaign_id = c1_.id WHERE c1_.id IN (?)"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0 FROM creator_campaign c0_ WHERE c0_.operator_id = ? ORDER BY c0_.name ASC, c0_.id ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c1_.metric_date AS metric_date_1, COALESCE(SUM(c1_.metric_posts), 0) AS sclr_2, COALESCE(SUM(c1_.metric_reach), 0) AS sclr_3, COALESCE(SUM(c1_.metric_impressions), 0) AS sclr_4, COALESCE(SUM(c1_.metric_likes), 0) AS sclr_5, COALESCE(SUM(c1_.metric_comments), 0) AS sclr_6 FROM content_metrics_history c1_ INNER JOIN creator_social_content c2_ ON c1_.content_id = c2_.id INNER JOIN creator_content_campaign c3_ ON (c3_.content_id = c2_.id) INNER JOIN creator_campaign c0_ ON c3_.campaign_id = c0_.id WHERE c0_.operator_id = ? AND (c1_.metric_date BETWEEN ? AND ?) AND c0_.id IN (?) GROUP BY c0_.id, c1_.metric_date ORDER BY c1_.metric_date ASC"
  "params" => [
    1 => 2
    2 => "2026-07-26 00:00:00"
    3 => "2026-08-04 00:00:00"
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#923
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#923}
    4 => Doctrine\DBAL\ParameterType {#906}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c1_.metric_date AS metric_date_1, COALESCE(SUM(c1_.metric_ftds), 0) AS sclr_2, COALESCE(SUM(c1_.metric_cpa), 0) AS sclr_3 FROM campaign_metrics_history c1_ INNER JOIN creator_campaign c0_ ON c1_.campaign_id = c0_.id WHERE c0_.operator_id = ? AND (c1_.metric_date BETWEEN ? AND ?) AND c0_.id IN (?) GROUP BY c0_.id, c1_.metric_date ORDER BY c1_.metric_date ASC"
  "params" => [
    1 => 2
    2 => "2026-07-26 00:00:00"
    3 => "2026-08-04 00:00:00"
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#923
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#923}
    4 => Doctrine\DBAL\ParameterType {#906}
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.email AS email_2 FROM creator_campaign_tipster c1_ INNER JOIN creator_campaign c2_ ON c1_.campaign_id = c2_.id INNER JOIN `user` u0_ ON c1_.tipster_id = u0_.id WHERE c2_.operator_id = ? GROUP BY u0_.id, u0_.name, u0_.email ORDER BY u0_.name ASC, u0_.email ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, COALESCE(SUM(c1_.expected_contents), 0) AS sclr_1 FROM creator_campaign_tipster c1_ INNER JOIN creator_campaign c2_ ON c1_.campaign_id = c2_.id INNER JOIN `user` u0_ ON c1_.tipster_id = u0_.id WHERE c2_.operator_id = ? AND c2_.id IN (?) GROUP BY u0_.id"
  "params" => [
    1 => 2
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#906}
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, c1_.metric_date AS metric_date_1, COALESCE(SUM(c1_.metric_posts), 0) AS sclr_2, COALESCE(SUM(c1_.metric_reach), 0) AS sclr_3, COALESCE(SUM(c1_.metric_impressions), 0) AS sclr_4, COALESCE(SUM(c1_.metric_likes), 0) AS sclr_5, COALESCE(SUM(c1_.metric_comments), 0) AS sclr_6 FROM content_metrics_history c1_ INNER JOIN creator_social_content c2_ ON c1_.content_id = c2_.id INNER JOIN creator_social_account c3_ ON c2_.social_account_id = c3_.id INNER JOIN `user` u0_ ON c3_.tipster_id = u0_.id INNER JOIN creator_content_campaign c4_ ON (c4_.content_id = c2_.id) INNER JOIN creator_campaign c5_ ON c4_.campaign_id = c5_.id WHERE c5_.operator_id = ? AND (c1_.metric_date BETWEEN ? AND ?) AND c5_.id IN (?) GROUP BY u0_.id, c1_.metric_date ORDER BY c1_.metric_date ASC"
  "params" => [
    1 => 2
    2 => "2026-07-26 00:00:00"
    3 => "2026-08-04 00:00:00"
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#923
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#923}
    4 => Doctrine\DBAL\ParameterType {#906}
  ]
]

[
  "sql" => "SELECT c0_.tipster_id AS sclr_0, c0_.metric_date AS metric_date_1, COALESCE(SUM(c0_.metric_clicks), 0) AS sclr_2, COALESCE(SUM(c0_.metric_ftds), 0) AS sclr_3, COALESCE(SUM(c0_.metric_cpa), 0) AS sclr_4 FROM campaign_metrics_history c0_ INNER JOIN creator_campaign c1_ ON c0_.campaign_id = c1_.id WHERE c1_.operator_id = ? AND (c0_.metric_date BETWEEN ? AND ?) AND c1_.id IN (?) GROUP BY c0_.tipster_id, c0_.metric_date ORDER BY c0_.metric_date ASC"
  "params" => [
    1 => 2
    2 => "2026-07-26 00:00:00"
    3 => "2026-08-04 00:00:00"
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#906
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#923
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#923}
    4 => Doctrine\DBAL\ParameterType {#906}
  ]
]

[
  "key" => "_security_main"
]