Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\HomeController"
  ]
  "request_uri" => "https://operators.la-demo.com/"
  "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 {#893
      +name: "INTEGER"
    }
  ]
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.description AS description_4, t0.content_requirements AS content_requirements_5, t0.hashtags AS hashtags_6, t0.min_posts AS min_posts_7, t0.budget AS budget_8, t0.cpa AS cpa_9, t0.ftds AS ftds_10, t0.clicks AS clicks_11, t0.target_likes AS target_likes_12, t0.target_clicks AS target_clicks_13, t0.target_cpa AS target_cpa_14, t0.target_ftds AS target_ftds_15, t0.target_impressions AS target_impressions_16, t0.target_comments AS target_comments_17, t0.target_reach AS target_reach_18, t0.beatandeal_campaign_id AS beatandeal_campaign_id_19, t0.starts_at AS starts_at_20, t0.ends_at AS ends_at_21, t0.status AS status_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.operator_id AS operator_id_25 FROM creator_campaign t0 WHERE t0.operator_id = ? ORDER BY t0.starts_at DESC, t0.name ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.conditions AS conditions_1, c0_.cpa AS cpa_2, c0_.ftds AS ftds_3, c0_.expected_contents AS expected_contents_4, c0_.assigned_at AS assigned_at_5, u1_.id AS id_6, u1_.email AS email_7, u1_.name AS name_8, u1_.country AS country_9, u1_.language AS language_10, u1_.roles AS roles_11, u1_.password AS password_12, u1_.enabled AS enabled_13, u1_.image AS image_14, u1_.beatandeal_tipster_id AS beatandeal_tipster_id_15, u1_.beatandeal_operator_ids AS beatandeal_operator_ids_16, u1_.created_at AS created_at_17, c0_.campaign_id AS campaign_id_18, c0_.tipster_id AS tipster_id_19 FROM creator_campaign_tipster c0_ INNER JOIN `user` u1_ ON c0_.tipster_id = u1_.id WHERE c0_.campaign_id IN (?, ?) ORDER BY u1_.name ASC, u1_.email ASC"
  "params" => [
    1 => 7
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#893}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.platform_user_id AS platform_user_id_1, c0_.username AS username_2, c0_.posts AS posts_3, c0_.followers AS followers_4, c0_.following AS following_5, c0_.profile_category AS profile_category_6, c0_.bio AS bio_7, c0_.external_url AS external_url_8, c0_.access_token AS access_token_9, c0_.token_expires_at AS token_expires_at_10, c0_.token_expired AS token_expired_11, c0_.is_active AS is_active_12, c0_.linked_at AS linked_at_13, u1_.id AS id_14, u1_.email AS email_15, u1_.name AS name_16, u1_.country AS country_17, u1_.language AS language_18, u1_.roles AS roles_19, u1_.password AS password_20, u1_.enabled AS enabled_21, u1_.image AS image_22, u1_.beatandeal_tipster_id AS beatandeal_tipster_id_23, u1_.beatandeal_operator_ids AS beatandeal_operator_ids_24, u1_.created_at AS created_at_25, c0_.tipster_id AS tipster_id_26, c0_.social_network_id AS social_network_id_27 FROM creator_social_account c0_ INNER JOIN `user` u1_ ON c0_.tipster_id = u1_.id WHERE u1_.id IN (?, ?) ORDER BY c0_.id ASC"
  "params" => [
    1 => 3
    2 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#893}
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, COUNT(c1_.id) AS sclr_1, COALESCE(SUM(c1_.reach), 0) AS sclr_2, COALESCE(SUM(c1_.impressions), 0) AS sclr_3, COALESCE(SUM(c1_.likes), 0) AS sclr_4, COALESCE(SUM(c1_.comments), 0) AS sclr_5 FROM creator_content_campaign c2_ INNER JOIN creator_social_content c1_ ON c2_.content_id = c1_.id INNER JOIN creator_social_account c3_ ON c1_.social_account_id = c3_.id INNER JOIN `user` u0_ ON c3_.tipster_id = u0_.id WHERE u0_.id IN (?, ?) AND c2_.campaign_id IN (?, ?) GROUP BY u0_.id"
  "params" => [
    1 => 3
    2 => 4
    3 => 7
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#893}
    3 => Doctrine\DBAL\ParameterType {#893}
    4 => Doctrine\DBAL\ParameterType {#893}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2 FROM social_network t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.assigned_at AS assigned_at_2, t0.content_id AS content_id_3, t0.campaign_id AS campaign_id_4 FROM creator_content_campaign t0 WHERE t0.campaign_id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.conditions AS conditions_2, t0.cpa AS cpa_3, t0.ftds AS ftds_4, t0.expected_contents AS expected_contents_5, t0.assigned_at AS assigned_at_6, t0.campaign_id AS campaign_id_7, t0.tipster_id AS tipster_id_8 FROM creator_campaign_tipster t0 WHERE t0.campaign_id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.assigned_at AS assigned_at_2, t0.content_id AS content_id_3, t0.campaign_id AS campaign_id_4 FROM creator_content_campaign t0 WHERE t0.campaign_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 26
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 27
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 227
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 228
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 202
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 203
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.platform AS platform_2, t0.platform_content_id AS platform_content_id_3, t0.type AS type_4, t0.caption AS caption_5, t0.data AS data_6, t0.media_url AS media_url_7, t0.media_type AS media_type_8, t0.video_url AS video_url_9, t0.permalink AS permalink_10, t0.thumbnail_url AS thumbnail_url_11, t0.impressions AS impressions_12, t0.reach AS reach_13, t0.likes AS likes_14, t0.comments AS comments_15, t0.shares AS shares_16, t0.saves AS saves_17, t0.published_at AS published_at_18, t0.synced_at AS synced_at_19, t0.social_account_id AS social_account_id_20 FROM creator_social_content t0 WHERE t0.id = ?"
  "params" => [
    1 => 235
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.conditions AS conditions_2, t0.cpa AS cpa_3, t0.ftds AS ftds_4, t0.expected_contents AS expected_contents_5, t0.assigned_at AS assigned_at_6, t0.campaign_id AS campaign_id_7, t0.tipster_id AS tipster_id_8 FROM creator_campaign_tipster t0 WHERE t0.campaign_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.assigned_at AS assigned_at_1, c1_.id AS id_2, c1_.platform AS platform_3, c1_.platform_content_id AS platform_content_id_4, c1_.type AS type_5, c1_.caption AS caption_6, c1_.data AS data_7, c1_.media_url AS media_url_8, c1_.media_type AS media_type_9, c1_.video_url AS video_url_10, c1_.permalink AS permalink_11, c1_.thumbnail_url AS thumbnail_url_12, c1_.impressions AS impressions_13, c1_.reach AS reach_14, c1_.likes AS likes_15, c1_.comments AS comments_16, c1_.shares AS shares_17, c1_.saves AS saves_18, c1_.published_at AS published_at_19, c1_.synced_at AS synced_at_20, c2_.id AS id_21, c2_.platform_user_id AS platform_user_id_22, c2_.username AS username_23, c2_.posts AS posts_24, c2_.followers AS followers_25, c2_.following AS following_26, c2_.profile_category AS profile_category_27, c2_.bio AS bio_28, c2_.external_url AS external_url_29, c2_.access_token AS access_token_30, c2_.token_expires_at AS token_expires_at_31, c2_.token_expired AS token_expired_32, c2_.is_active AS is_active_33, c2_.linked_at AS linked_at_34, u3_.id AS id_35, u3_.email AS email_36, u3_.name AS name_37, u3_.country AS country_38, u3_.language AS language_39, u3_.roles AS roles_40, u3_.password AS password_41, u3_.enabled AS enabled_42, u3_.image AS image_43, u3_.beatandeal_tipster_id AS beatandeal_tipster_id_44, u3_.beatandeal_operator_ids AS beatandeal_operator_ids_45, u3_.created_at AS created_at_46, c0_.content_id AS content_id_47, c0_.campaign_id AS campaign_id_48, c1_.social_account_id AS social_account_id_49, c2_.tipster_id AS tipster_id_50, c2_.social_network_id AS social_network_id_51 FROM creator_content_campaign c0_ INNER JOIN creator_social_content c1_ ON c0_.content_id = c1_.id INNER JOIN creator_campaign c4_ ON c0_.campaign_id = c4_.id LEFT JOIN creator_social_account c2_ ON c1_.social_account_id = c2_.id LEFT JOIN `user` u3_ ON c2_.tipster_id = u3_.id WHERE c4_.id IN (?, ?) ORDER BY c1_.published_at DESC, c0_.assigned_at DESC, c0_.id DESC LIMIT 8"
  "params" => [
    1 => 7
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#893}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.assigned_at AS assigned_at_1, c1_.id AS id_2, c1_.platform AS platform_3, c1_.platform_content_id AS platform_content_id_4, c1_.type AS type_5, c1_.caption AS caption_6, c1_.data AS data_7, c1_.media_url AS media_url_8, c1_.media_type AS media_type_9, c1_.video_url AS video_url_10, c1_.permalink AS permalink_11, c1_.thumbnail_url AS thumbnail_url_12, c1_.impressions AS impressions_13, c1_.reach AS reach_14, c1_.likes AS likes_15, c1_.comments AS comments_16, c1_.shares AS shares_17, c1_.saves AS saves_18, c1_.published_at AS published_at_19, c1_.synced_at AS synced_at_20, c2_.id AS id_21, c2_.platform_user_id AS platform_user_id_22, c2_.username AS username_23, c2_.posts AS posts_24, c2_.followers AS followers_25, c2_.following AS following_26, c2_.profile_category AS profile_category_27, c2_.bio AS bio_28, c2_.external_url AS external_url_29, c2_.access_token AS access_token_30, c2_.token_expires_at AS token_expires_at_31, c2_.token_expired AS token_expired_32, c2_.is_active AS is_active_33, c2_.linked_at AS linked_at_34, u3_.id AS id_35, u3_.email AS email_36, u3_.name AS name_37, u3_.country AS country_38, u3_.language AS language_39, u3_.roles AS roles_40, u3_.password AS password_41, u3_.enabled AS enabled_42, u3_.image AS image_43, u3_.beatandeal_tipster_id AS beatandeal_tipster_id_44, u3_.beatandeal_operator_ids AS beatandeal_operator_ids_45, u3_.created_at AS created_at_46, c0_.content_id AS content_id_47, c0_.campaign_id AS campaign_id_48, c1_.social_account_id AS social_account_id_49, c2_.tipster_id AS tipster_id_50, c2_.social_network_id AS social_network_id_51 FROM creator_content_campaign c0_ INNER JOIN creator_social_content c1_ ON c0_.content_id = c1_.id INNER JOIN creator_campaign c4_ ON c0_.campaign_id = c4_.id LEFT JOIN creator_social_account c2_ ON c1_.social_account_id = c2_.id LEFT JOIN `user` u3_ ON c2_.tipster_id = u3_.id WHERE c4_.id IN (?, ?) ORDER BY c1_.published_at DESC, c0_.assigned_at DESC, c0_.id DESC LIMIT 10"
  "params" => [
    1 => 7
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#893}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.assigned_at AS assigned_at_1, c1_.id AS id_2, c1_.platform AS platform_3, c1_.platform_content_id AS platform_content_id_4, c1_.type AS type_5, c1_.caption AS caption_6, c1_.data AS data_7, c1_.media_url AS media_url_8, c1_.media_type AS media_type_9, c1_.video_url AS video_url_10, c1_.permalink AS permalink_11, c1_.thumbnail_url AS thumbnail_url_12, c1_.impressions AS impressions_13, c1_.reach AS reach_14, c1_.likes AS likes_15, c1_.comments AS comments_16, c1_.shares AS shares_17, c1_.saves AS saves_18, c1_.published_at AS published_at_19, c1_.synced_at AS synced_at_20, c2_.id AS id_21, c2_.platform_user_id AS platform_user_id_22, c2_.username AS username_23, c2_.posts AS posts_24, c2_.followers AS followers_25, c2_.following AS following_26, c2_.profile_category AS profile_category_27, c2_.bio AS bio_28, c2_.external_url AS external_url_29, c2_.access_token AS access_token_30, c2_.token_expires_at AS token_expires_at_31, c2_.token_expired AS token_expired_32, c2_.is_active AS is_active_33, c2_.linked_at AS linked_at_34, u3_.id AS id_35, u3_.email AS email_36, u3_.name AS name_37, u3_.country AS country_38, u3_.language AS language_39, u3_.roles AS roles_40, u3_.password AS password_41, u3_.enabled AS enabled_42, u3_.image AS image_43, u3_.beatandeal_tipster_id AS beatandeal_tipster_id_44, u3_.beatandeal_operator_ids AS beatandeal_operator_ids_45, u3_.created_at AS created_at_46, c0_.content_id AS content_id_47, c0_.campaign_id AS campaign_id_48, c1_.social_account_id AS social_account_id_49, c2_.tipster_id AS tipster_id_50, c2_.social_network_id AS social_network_id_51 FROM creator_content_campaign c0_ INNER JOIN creator_social_content c1_ ON c0_.content_id = c1_.id INNER JOIN creator_campaign c4_ ON c0_.campaign_id = c4_.id LEFT JOIN creator_social_account c2_ ON c1_.social_account_id = c2_.id LEFT JOIN `user` u3_ ON c2_.tipster_id = u3_.id WHERE c4_.id IN (?, ?) AND c2_.tipster_id = ? AND c1_.published_at >= ? AND c1_.published_at <= ? ORDER BY c1_.published_at DESC, c0_.assigned_at DESC, c0_.id DESC LIMIT 10"
  "params" => [
    1 => 7
    2 => 1
    3 => 3
    4 => "2026-07-26 00:00:00"
    5 => "2026-08-04 23:59:59"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#893}
    3 => Doctrine\DBAL\ParameterType {#893}
    4 => Doctrine\DBAL\ParameterType {#1958
      +name: "STRING"
    }
    5 => Doctrine\DBAL\ParameterType {#1958}
  ]
]

[
  "sql" => "SELECT COUNT(c0_.id) AS sclr_0 FROM creator_content_campaign c0_ INNER JOIN creator_social_content c1_ ON c0_.content_id = c1_.id INNER JOIN creator_campaign c2_ ON c0_.campaign_id = c2_.id LEFT JOIN creator_social_account c3_ ON c1_.social_account_id = c3_.id WHERE c2_.id IN (?, ?)"
  "params" => [
    1 => 7
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#893
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#893}
  ]
]

[
  "key" => "_security_main"
]