Symfony Profiler

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

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 (7, 1) AND c2_.tipster_id = 3 AND c1_.published_at >= '2026-07-26 00:00:00' AND c1_.published_at <= '2026-08-04 23:59:59' ORDER BY c1_.published_at DESC, c0_.assigned_at DESC, c0_.id DESC LIMIT 10;

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

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 = 2 ORDER BY t0.starts_at DESC, t0.name ASC;

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 (?, ?)
  AND c3_.tipster_id = ?
  AND c1_.published_at >= ?
  AND c1_.published_at <= ?

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 (7, 1) AND c3_.tipster_id = 3 AND c1_.published_at >= '2026-07-26 00:00:00' AND c1_.published_at <= '2026-08-04 23:59:59';

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 = ?

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 = 2;