Symfony Profiler

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;

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 ?
  )
GROUP BY
  c0_.metric_date
ORDER BY
  c0_.metric_date ASC

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 = 2 AND (c0_.metric_date BETWEEN '2026-07-27 00:00:00' AND '2026-08-04 00:00:00') GROUP BY c0_.metric_date ORDER BY c0_.metric_date ASC;

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 ?
  )
GROUP BY
  c0_.metric_date
ORDER BY
  c0_.metric_date ASC

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 = 2 AND (c0_.metric_date BETWEEN '2026-07-27 00:00:00' AND '2026-08-04 00:00:00') GROUP BY c0_.metric_date ORDER BY c0_.metric_date ASC;

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 = ?
GROUP BY
  c0_.type

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 = 2 AND c1_.metric_date = '2026-08-04 00:00:00' GROUP BY c0_.type;

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

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 = 2 AND (c1_.metric_date BETWEEN '2026-07-27 00:00:00' AND '2026-08-04 00:00:00');

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

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 = 2 AND (c1_.metric_date BETWEEN '2026-07-27 00:00:00' AND '2026-08-04 00:00:00');

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 (?)

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 (1);

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 (?)

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 (1);

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 (?)

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 (1);

SELECT
  c0_.id AS id_0
FROM
  creator_campaign c0_
WHERE
  c0_.operator_id = ?
ORDER BY
  c0_.name ASC,
  c0_.id ASC

SELECT c0_.id AS id_0 FROM creator_campaign c0_ WHERE c0_.operator_id = 2 ORDER BY c0_.name ASC, c0_.id ASC;

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 ?
  )
GROUP BY
  c0_.id,
  c1_.metric_date
ORDER BY
  c1_.metric_date ASC

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 = 2 AND (c1_.metric_date BETWEEN '2026-07-27 00:00:00' AND '2026-08-04 00:00:00') GROUP BY c0_.id, c1_.metric_date ORDER BY c1_.metric_date ASC;

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 ?
  )
GROUP BY
  c0_.id,
  c1_.metric_date
ORDER BY
  c1_.metric_date ASC

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 = 2 AND (c1_.metric_date BETWEEN '2026-07-27 00:00:00' AND '2026-08-04 00:00:00') GROUP BY c0_.id, c1_.metric_date ORDER BY c1_.metric_date ASC;

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

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 = 2 GROUP BY u0_.id, u0_.name, u0_.email ORDER BY u0_.name ASC, u0_.email ASC;

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 = ?
GROUP BY
  u0_.id

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 = 2 GROUP BY u0_.id;

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 ?
  )
GROUP BY
  u0_.id,
  c1_.metric_date
ORDER BY
  c1_.metric_date ASC

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 = 2 AND (c1_.metric_date BETWEEN '2026-07-27 00:00:00' AND '2026-08-04 00:00:00') GROUP BY u0_.id, c1_.metric_date ORDER BY c1_.metric_date ASC;

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 ?
  )
GROUP BY
  c0_.tipster_id,
  c0_.metric_date
ORDER BY
  c0_.metric_date ASC

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 = 2 AND (c0_.metric_date BETWEEN '2026-07-27 00:00:00' AND '2026-08-04 00:00:00') GROUP BY c0_.tipster_id, c0_.metric_date ORDER BY c0_.metric_date ASC;