Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.status AS status_1,
  u0_.email AS email_2,
  u0_.pending_email AS pending_email_3,
  u0_.phone_number AS phone_number_4,
  u0_.first_name AS first_name_5,
  u0_.last_name AS last_name_6,
  u0_.language AS language_7,
  u0_.blocked_until AS blocked_until_8,
  u0_.block_scope AS block_scope_9,
  u0_.created_at AS created_at_10,
  u0_.updated_at AS updated_at_11,
  u0_.last_login_at AS last_login_at_12,
  u0_.last_activity_at AS last_activity_at_13,
  u0_.previous_activity_at AS previous_activity_at_14,
  u0_.returned_at AS returned_at_15,
  u0_.last_activity AS last_activity_16,
  u0_.deleted_at AS deleted_at_17,
  u0_.credentials_changed_at AS credentials_changed_at_18,
  s1_.password AS password_19,
  s1_.company_name AS company_name_20,
  s1_.company_website AS company_website_21,
  s1_.job_title AS job_title_22,
  s1_.country AS country_23,
  s1_.about_us AS about_us_24,
  s1_.promote AS promote_25,
  s1_.credit AS credit_26,
  s1_.with_payment_process AS with_payment_process_27,
  s1_.has_creator_account AS has_creator_account_28,
  s1_.notify_email AS notify_email_29,
  s1_.notify_sms AS notify_sms_30,
  s1_.credit_limit AS credit_limit_31,
  s1_.used_credit AS used_credit_32,
  s1_.store_credit AS store_credit_33,
  s1_.permissions AS permissions_34,
  s1_.total_creators AS total_creators_35,
  s1_.total_videos AS total_videos_36,
  s1_.total_views AS total_views_37,
  s1_.total_price AS total_price_38,
  s1_.referral_source AS referral_source_39,
  s1_.referral_source_other AS referral_source_other_40,
  s1_.paypal_id AS paypal_id_41,
  u0_.role AS role_42
FROM
  sponsor s1_
  INNER JOIN user u0_ ON s1_.id = u0_.id
WHERE
  u0_.id = ?

SELECT u0_.id AS id_0, u0_.status AS status_1, u0_.email AS email_2, u0_.pending_email AS pending_email_3, u0_.phone_number AS phone_number_4, u0_.first_name AS first_name_5, u0_.last_name AS last_name_6, u0_.language AS language_7, u0_.blocked_until AS blocked_until_8, u0_.block_scope AS block_scope_9, u0_.created_at AS created_at_10, u0_.updated_at AS updated_at_11, u0_.last_login_at AS last_login_at_12, u0_.last_activity_at AS last_activity_at_13, u0_.previous_activity_at AS previous_activity_at_14, u0_.returned_at AS returned_at_15, u0_.last_activity AS last_activity_16, u0_.deleted_at AS deleted_at_17, u0_.credentials_changed_at AS credentials_changed_at_18, s1_.password AS password_19, s1_.company_name AS company_name_20, s1_.company_website AS company_website_21, s1_.job_title AS job_title_22, s1_.country AS country_23, s1_.about_us AS about_us_24, s1_.promote AS promote_25, s1_.credit AS credit_26, s1_.with_payment_process AS with_payment_process_27, s1_.has_creator_account AS has_creator_account_28, s1_.notify_email AS notify_email_29, s1_.notify_sms AS notify_sms_30, s1_.credit_limit AS credit_limit_31, s1_.used_credit AS used_credit_32, s1_.store_credit AS store_credit_33, s1_.permissions AS permissions_34, s1_.total_creators AS total_creators_35, s1_.total_videos AS total_videos_36, s1_.total_views AS total_views_37, s1_.total_price AS total_price_38, s1_.referral_source AS referral_source_39, s1_.referral_source_other AS referral_source_other_40, s1_.paypal_id AS paypal_id_41, u0_.role AS role_42 FROM sponsor s1_ INNER JOIN user u0_ ON s1_.id = u0_.id WHERE u0_.id = '2667810';

SELECT
  t0.permission AS permission_1,
  t0.services_enabled AS services_enabled_2,
  t0.reported_at AS reported_at_3,
  t0.id AS id_4
FROM
  user_location_permission t0
WHERE
  t0.id = ?

SELECT t0.permission AS permission_1, t0.services_enabled AS services_enabled_2, t0.reported_at AS reported_at_3, t0.id AS id_4 FROM user_location_permission t0 WHERE t0.id = 2667810;

SELECT
  t0.value AS value_1,
  t0.changed_at AS changed_at_2,
  t0.id AS id_3
FROM
  payment_balance t0
WHERE
  t0.id = ?

SELECT t0.value AS value_1, t0.changed_at AS changed_at_2, t0.id AS id_3 FROM payment_balance t0 WHERE t0.id = 2667810;

SELECT
  t0.code AS code_1,
  t0.is_enabled AS is_enabled_2,
  t0.duration_days_per_referred_user AS duration_days_per_referred_user_3,
  t0.referred_by_ended_at AS referred_by_ended_at_4,
  t0.referral_activity_commission_percent AS referral_activity_commission_percent_5,
  t0.referral_new_campaign_commission_percent AS referral_new_campaign_commission_percent_6,
  t0.balance AS balance_7,
  t0.id AS id_8,
  t0.referred_by_id AS referred_by_id_9
FROM
  referral t0
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.is_enabled AS is_enabled_2, t0.duration_days_per_referred_user AS duration_days_per_referred_user_3, t0.referred_by_ended_at AS referred_by_ended_at_4, t0.referral_activity_commission_percent AS referral_activity_commission_percent_5, t0.referral_new_campaign_commission_percent AS referral_new_campaign_commission_percent_6, t0.balance AS balance_7, t0.id AS id_8, t0.referred_by_id AS referred_by_id_9 FROM referral t0 WHERE t0.id = 2667810;

SELECT
  t0.id AS id_1,
  t0.platform AS platform_2,
  t0.access_token AS access_token_3,
  t0.name AS name_4,
  t0.status AS status_5,
  t0.gender AS gender_6,
  t0.instructions AS instructions_7,
  t0.description AS description_8,
  t0.brief_action AS brief_action_9,
  t0.brief_reference_url AS brief_reference_url_10,
  t0.brief_hashtags AS brief_hashtags_11,
  t0.brief_screen_text AS brief_screen_text_12,
  t0.brief_screen_text_required AS brief_screen_text_required_13,
  t0.brief_context AS brief_context_14,
  t0.brief_structured AS brief_structured_15,
  t0.comment AS comment_16,
  t0.is_draft_video AS is_draft_video_17,
  t0.draft_video_price AS draft_video_price_18,
  t0.amount AS amount_19,
  t0.boost AS boost_20,
  t0.bonus AS bonus_21,
  t0.paid AS paid_22,
  t0.reserved AS reserved_23,
  t0.upsell_amount AS upsell_amount_24,
  t0.upsell_reserved AS upsell_reserved_25,
  t0.upsell_paid AS upsell_paid_26,
  t0.deadline_extension_count AS deadline_extension_count_27,
  t0.min_views_per_video AS min_views_per_video_28,
  t0.max_views_per_video AS max_views_per_video_29,
  t0.min_follower_count AS min_follower_count_30,
  t0.max_follower_count AS max_follower_count_31,
  t0.min_video_count AS min_video_count_32,
  t0.max_video_count AS max_video_count_33,
  t0.min_like_count AS min_like_count_34,
  t0.max_like_count AS max_like_count_35,
  t0.age_from AS age_from_36,
  t0.age_to AS age_to_37,
  t0.direction AS direction_38,
  t0.flat_price AS flat_price_39,
  t0.vip_creator AS vip_creator_40,
  t0.verified_creator AS verified_creator_41,
  t0.unverified_creator AS unverified_creator_42,
  t0.creator_geolocation_enabled AS creator_geolocation_enabled_43,
  t0.creator_geolocation_disabled AS creator_geolocation_disabled_44,
  t0.skipped_creator AS skipped_creator_45,
  t0.non_skipped_creator AS non_skipped_creator_46,
  t0.max_price_per_video AS max_price_per_video_47,
  t0.automatically_apply AS automatically_apply_48,
  t0.automatically_pay AS automatically_pay_49,
  t0.hide_audio AS hide_audio_50,
  t0.discovery_slice_enabled AS discovery_slice_enabled_51,
  t0.discovery_slice_percent AS discovery_slice_percent_52,
  t0.surge_percent AS surge_percent_53,
  t0.surge_ends_at AS surge_ends_at_54,
  t0.stat_pending AS stat_pending_55,
  t0.stat_creators AS stat_creators_56,
  t0.stat_videos AS stat_videos_57,
  t0.stat_views AS stat_views_58,
  t0.stat_likes AS stat_likes_59,
  t0.stat_comments AS stat_comments_60,
  t0.stat_shares AS stat_shares_61,
  t0.stat_followers AS stat_followers_62,
  t0.deadline_at AS deadline_at_63,
  t0.created_at AS created_at_64,
  t0.updated_at AS updated_at_65,
  t0.payed_at AS payed_at_66,
  t0.completed_at AS completed_at_67,
  t0.retention_checked_at AS retention_checked_at_68,
  t0.activated_at AS activated_at_69,
  t0.survey_targeting AS survey_targeting_70,
  t0.content_languages AS content_languages_71,
  t0.creator_communities AS creator_communities_72,
  t0.niche_semantic_matches AS niche_semantic_matches_73,
  t0.niche_semantic_buckets AS niche_semantic_buckets_74,
  t0.niches AS niches_75,
  t0.purchase_order AS purchase_order_76,
  t0.purchase_order_status AS purchase_order_status_77,
  t0.notification_settings AS notification_settings_78,
  t0.accesses AS accesses_79,
  t0.goal AS goal_80,
  t0.min_engagment_rate AS min_engagment_rate_81,
  t0.max_engagment_rate AS max_engagment_rate_82,
  t0.is_show_draft AS is_show_draft_83,
  t0.is_contest AS is_contest_84,
  t0.autocomplete_schema AS autocomplete_schema_85,
  t0.inbox_paid_percent AS inbox_paid_percent_86,
  t0.analytics_targeting AS analytics_targeting_87,
  t0.other_sponsor_personal_bonus AS other_sponsor_personal_bonus_88,
  t0.money_returned AS money_returned_89,
  t0.desired_creator_link1 AS desired_creator_link1_90,
  t0.desired_creator_link2 AS desired_creator_link2_91,
  t0.desired_creator_link3 AS desired_creator_link3_92,
  t0.speed_id AS speed_id_93,
  t0.sponsor_id AS sponsor_id_94,
  t0.song_id AS song_id_95,
  t0.img AS img_96,
  t0.created_by_manager_id AS created_by_manager_id_97
FROM
  campaign t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.platform AS platform_2, t0.access_token AS access_token_3, t0.name AS name_4, t0.status AS status_5, t0.gender AS gender_6, t0.instructions AS instructions_7, t0.description AS description_8, t0.brief_action AS brief_action_9, t0.brief_reference_url AS brief_reference_url_10, t0.brief_hashtags AS brief_hashtags_11, t0.brief_screen_text AS brief_screen_text_12, t0.brief_screen_text_required AS brief_screen_text_required_13, t0.brief_context AS brief_context_14, t0.brief_structured AS brief_structured_15, t0.comment AS comment_16, t0.is_draft_video AS is_draft_video_17, t0.draft_video_price AS draft_video_price_18, t0.amount AS amount_19, t0.boost AS boost_20, t0.bonus AS bonus_21, t0.paid AS paid_22, t0.reserved AS reserved_23, t0.upsell_amount AS upsell_amount_24, t0.upsell_reserved AS upsell_reserved_25, t0.upsell_paid AS upsell_paid_26, t0.deadline_extension_count AS deadline_extension_count_27, t0.min_views_per_video AS min_views_per_video_28, t0.max_views_per_video AS max_views_per_video_29, t0.min_follower_count AS min_follower_count_30, t0.max_follower_count AS max_follower_count_31, t0.min_video_count AS min_video_count_32, t0.max_video_count AS max_video_count_33, t0.min_like_count AS min_like_count_34, t0.max_like_count AS max_like_count_35, t0.age_from AS age_from_36, t0.age_to AS age_to_37, t0.direction AS direction_38, t0.flat_price AS flat_price_39, t0.vip_creator AS vip_creator_40, t0.verified_creator AS verified_creator_41, t0.unverified_creator AS unverified_creator_42, t0.creator_geolocation_enabled AS creator_geolocation_enabled_43, t0.creator_geolocation_disabled AS creator_geolocation_disabled_44, t0.skipped_creator AS skipped_creator_45, t0.non_skipped_creator AS non_skipped_creator_46, t0.max_price_per_video AS max_price_per_video_47, t0.automatically_apply AS automatically_apply_48, t0.automatically_pay AS automatically_pay_49, t0.hide_audio AS hide_audio_50, t0.discovery_slice_enabled AS discovery_slice_enabled_51, t0.discovery_slice_percent AS discovery_slice_percent_52, t0.surge_percent AS surge_percent_53, t0.surge_ends_at AS surge_ends_at_54, t0.stat_pending AS stat_pending_55, t0.stat_creators AS stat_creators_56, t0.stat_videos AS stat_videos_57, t0.stat_views AS stat_views_58, t0.stat_likes AS stat_likes_59, t0.stat_comments AS stat_comments_60, t0.stat_shares AS stat_shares_61, t0.stat_followers AS stat_followers_62, t0.deadline_at AS deadline_at_63, t0.created_at AS created_at_64, t0.updated_at AS updated_at_65, t0.payed_at AS payed_at_66, t0.completed_at AS completed_at_67, t0.retention_checked_at AS retention_checked_at_68, t0.activated_at AS activated_at_69, t0.survey_targeting AS survey_targeting_70, t0.content_languages AS content_languages_71, t0.creator_communities AS creator_communities_72, t0.niche_semantic_matches AS niche_semantic_matches_73, t0.niche_semantic_buckets AS niche_semantic_buckets_74, t0.niches AS niches_75, t0.purchase_order AS purchase_order_76, t0.purchase_order_status AS purchase_order_status_77, t0.notification_settings AS notification_settings_78, t0.accesses AS accesses_79, t0.goal AS goal_80, t0.min_engagment_rate AS min_engagment_rate_81, t0.max_engagment_rate AS max_engagment_rate_82, t0.is_show_draft AS is_show_draft_83, t0.is_contest AS is_contest_84, t0.autocomplete_schema AS autocomplete_schema_85, t0.inbox_paid_percent AS inbox_paid_percent_86, t0.analytics_targeting AS analytics_targeting_87, t0.other_sponsor_personal_bonus AS other_sponsor_personal_bonus_88, t0.money_returned AS money_returned_89, t0.desired_creator_link1 AS desired_creator_link1_90, t0.desired_creator_link2 AS desired_creator_link2_91, t0.desired_creator_link3 AS desired_creator_link3_92, t0.speed_id AS speed_id_93, t0.sponsor_id AS sponsor_id_94, t0.song_id AS song_id_95, t0.img AS img_96, t0.created_by_manager_id AS created_by_manager_id_97 FROM campaign t0 WHERE t0.id = 17256;

SELECT
  t1.id AS id_2,
  t1.status AS status_3,
  t1.email AS email_4,
  t1.pending_email AS pending_email_5,
  t1.phone_number AS phone_number_6,
  t1.first_name AS first_name_7,
  t1.last_name AS last_name_8,
  t1.language AS language_9,
  t1.blocked_until AS blocked_until_10,
  t1.block_scope AS block_scope_11,
  t1.created_at AS created_at_12,
  t1.updated_at AS updated_at_13,
  t1.last_login_at AS last_login_at_14,
  t1.last_activity_at AS last_activity_at_15,
  t1.previous_activity_at AS previous_activity_at_16,
  t1.returned_at AS returned_at_17,
  t1.last_activity AS last_activity_18,
  t1.deleted_at AS deleted_at_19,
  t1.credentials_changed_at AS credentials_changed_at_20,
  t0.password AS password_21,
  t0.company_name AS company_name_22,
  t0.company_website AS company_website_23,
  t0.job_title AS job_title_24,
  t0.country AS country_25,
  t0.about_us AS about_us_26,
  t0.promote AS promote_27,
  t0.credit AS credit_28,
  t0.with_payment_process AS with_payment_process_29,
  t0.has_creator_account AS has_creator_account_30,
  t0.notify_email AS notify_email_31,
  t0.notify_sms AS notify_sms_32,
  t0.credit_limit AS credit_limit_33,
  t0.used_credit AS used_credit_34,
  t0.store_credit AS store_credit_35,
  t0.permissions AS permissions_36,
  t0.total_creators AS total_creators_37,
  t0.total_videos AS total_videos_38,
  t0.total_views AS total_views_39,
  t0.total_price AS total_price_40,
  t0.referral_source AS referral_source_41,
  t0.referral_source_other AS referral_source_other_42,
  t0.paypal_id AS paypal_id_43,
  t1.role
FROM
  sponsor t0
  INNER JOIN user t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.status AS status_3, t1.email AS email_4, t1.pending_email AS pending_email_5, t1.phone_number AS phone_number_6, t1.first_name AS first_name_7, t1.last_name AS last_name_8, t1.language AS language_9, t1.blocked_until AS blocked_until_10, t1.block_scope AS block_scope_11, t1.created_at AS created_at_12, t1.updated_at AS updated_at_13, t1.last_login_at AS last_login_at_14, t1.last_activity_at AS last_activity_at_15, t1.previous_activity_at AS previous_activity_at_16, t1.returned_at AS returned_at_17, t1.last_activity AS last_activity_18, t1.deleted_at AS deleted_at_19, t1.credentials_changed_at AS credentials_changed_at_20, t0.password AS password_21, t0.company_name AS company_name_22, t0.company_website AS company_website_23, t0.job_title AS job_title_24, t0.country AS country_25, t0.about_us AS about_us_26, t0.promote AS promote_27, t0.credit AS credit_28, t0.with_payment_process AS with_payment_process_29, t0.has_creator_account AS has_creator_account_30, t0.notify_email AS notify_email_31, t0.notify_sms AS notify_sms_32, t0.credit_limit AS credit_limit_33, t0.used_credit AS used_credit_34, t0.store_credit AS store_credit_35, t0.permissions AS permissions_36, t0.total_creators AS total_creators_37, t0.total_videos AS total_videos_38, t0.total_views AS total_views_39, t0.total_price AS total_price_40, t0.referral_source AS referral_source_41, t0.referral_source_other AS referral_source_other_42, t0.paypal_id AS paypal_id_43, t1.role FROM sponsor t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = 2678429;

SELECT
  t0.permission AS permission_1,
  t0.services_enabled AS services_enabled_2,
  t0.reported_at AS reported_at_3,
  t0.id AS id_4
FROM
  user_location_permission t0
WHERE
  t0.id = ?

SELECT t0.permission AS permission_1, t0.services_enabled AS services_enabled_2, t0.reported_at AS reported_at_3, t0.id AS id_4 FROM user_location_permission t0 WHERE t0.id = 2678429;

SELECT
  t0.value AS value_1,
  t0.changed_at AS changed_at_2,
  t0.id AS id_3
FROM
  payment_balance t0
WHERE
  t0.id = ?

SELECT t0.value AS value_1, t0.changed_at AS changed_at_2, t0.id AS id_3 FROM payment_balance t0 WHERE t0.id = 2678429;

SELECT
  t0.code AS code_1,
  t0.is_enabled AS is_enabled_2,
  t0.duration_days_per_referred_user AS duration_days_per_referred_user_3,
  t0.referred_by_ended_at AS referred_by_ended_at_4,
  t0.referral_activity_commission_percent AS referral_activity_commission_percent_5,
  t0.referral_new_campaign_commission_percent AS referral_new_campaign_commission_percent_6,
  t0.balance AS balance_7,
  t0.id AS id_8,
  t0.referred_by_id AS referred_by_id_9
FROM
  referral t0
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.is_enabled AS is_enabled_2, t0.duration_days_per_referred_user AS duration_days_per_referred_user_3, t0.referred_by_ended_at AS referred_by_ended_at_4, t0.referral_activity_commission_percent AS referral_activity_commission_percent_5, t0.referral_new_campaign_commission_percent AS referral_new_campaign_commission_percent_6, t0.balance AS balance_7, t0.id AS id_8, t0.referred_by_id AS referred_by_id_9 FROM referral t0 WHERE t0.id = 2678429;

SELECT
  t0.id AS id_1,
  t0.card_id AS card_id_2,
  t0.last_digits AS last_digits_3,
  t0.brand AS brand_4,
  t0.expired_at AS expired_at_5,
  t0.user_id AS user_id_6
FROM
  payment_method t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.card_id AS card_id_2, t0.last_digits AS last_digits_3, t0.brand AS brand_4, t0.expired_at AS expired_at_5, t0.user_id AS user_id_6 FROM payment_method t0 WHERE t0.user_id = '2678429';

SELECT
  COALESCE(
    SUM(
      CASE WHEN c0_.amount > 0 THEN
        c0_.amount
      ELSE
        0
      END
    ),
    0
  ) AS sclr_0
FROM
  campaign c0_
WHERE
  c0_.sponsor_id = ?
  AND c0_.status IN (?, ?)

SELECT COALESCE(SUM(CASE WHEN c0_.amount > 0 THEN c0_.amount ELSE 0 END), 0) AS sclr_0 FROM campaign c0_ WHERE c0_.sponsor_id = '2678429' AND c0_.status IN (1, 3);

SELECT
  COALESCE(
    SUM(
      CASE WHEN c0_.amount > 0 THEN
        c0_.amount
      ELSE
        0
      END
    ),
    0
  ) AS sclr_0
FROM
  campaign c0_
WHERE
  c0_.sponsor_id = ?
  AND c0_.status = ?
  AND c0_.money_returned = ?

SELECT COALESCE(SUM(CASE WHEN c0_.amount > 0 THEN c0_.amount ELSE 0 END), 0) AS sclr_0 FROM campaign c0_ WHERE c0_.sponsor_id = '2678429' AND c0_.status = 2 AND c0_.money_returned = 0;

SELECT
  COALESCE(
    SUM(
      CASE WHEN a0_.upsell_approved_price > 0 THEN
        a0_.upsell_approved_price
      ELSE
        0
      END
    ),
    0
  ) AS sclr_0
FROM
  activity a0_
  INNER JOIN campaign c1_ ON a0_.campaign_id = c1_.id
WHERE
  c1_.sponsor_id = ?
  AND a0_.upsell_status = ?
  AND a0_.payed_at IS NULL

SELECT COALESCE(SUM(CASE WHEN a0_.upsell_approved_price > 0 THEN a0_.upsell_approved_price ELSE 0 END), 0) AS sclr_0 FROM activity a0_ INNER JOIN campaign c1_ ON a0_.campaign_id = c1_.id WHERE c1_.sponsor_id = '2678429' AND a0_.upsell_status = 2 AND a0_.payed_at IS NULL;

SELECT
  COALESCE(
    SUM(
      CASE WHEN c0_.amount > 0 THEN
        c0_.amount
      ELSE
        0
      END
    ),
    0
  ) AS sclr_0
FROM
  campaign c0_
WHERE
  c0_.sponsor_id = ?
  AND c0_.status IN (?, ?)

SELECT COALESCE(SUM(CASE WHEN c0_.amount > 0 THEN c0_.amount ELSE 0 END), 0) AS sclr_0 FROM campaign c0_ WHERE c0_.sponsor_id = '2678429' AND c0_.status IN (1, 3);

SELECT
  COALESCE(
    SUM(
      CASE WHEN c0_.amount > 0 THEN
        c0_.amount
      ELSE
        0
      END
    ),
    0
  ) AS sclr_0
FROM
  campaign c0_
WHERE
  c0_.sponsor_id = ?
  AND c0_.status = ?
  AND c0_.money_returned = ?

SELECT COALESCE(SUM(CASE WHEN c0_.amount > 0 THEN c0_.amount ELSE 0 END), 0) AS sclr_0 FROM campaign c0_ WHERE c0_.sponsor_id = '2678429' AND c0_.status = 2 AND c0_.money_returned = 0;

SELECT
  COALESCE(
    SUM(
      CASE WHEN a0_.upsell_approved_price > 0 THEN
        a0_.upsell_approved_price
      ELSE
        0
      END
    ),
    0
  ) AS sclr_0
FROM
  activity a0_
  INNER JOIN campaign c1_ ON a0_.campaign_id = c1_.id
WHERE
  c1_.sponsor_id = ?
  AND a0_.upsell_status = ?
  AND a0_.payed_at IS NULL

SELECT COALESCE(SUM(CASE WHEN a0_.upsell_approved_price > 0 THEN a0_.upsell_approved_price ELSE 0 END), 0) AS sclr_0 FROM activity a0_ INNER JOIN campaign c1_ ON a0_.campaign_id = c1_.id WHERE c1_.sponsor_id = '2678429' AND a0_.upsell_status = 2 AND a0_.payed_at IS NULL;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso_code AS iso_code_3,
  t0.sms_enabled AS sms_enabled_4,
  t0.cpm_rate AS cpm_rate_5,
  t0.region_id AS region_id_6
FROM
  country t0
  INNER JOIN campaign_country ON t0.id = campaign_country.country_id
WHERE
  campaign_country.campaign_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.sms_enabled AS sms_enabled_4, t0.cpm_rate AS cpm_rate_5, t0.region_id AS region_id_6 FROM country t0 INNER JOIN campaign_country ON t0.id = campaign_country.country_id WHERE campaign_country.campaign_id = 17256;

SELECT
  t1.id AS id_2,
  t1.status AS status_3,
  t1.email AS email_4,
  t1.pending_email AS pending_email_5,
  t1.phone_number AS phone_number_6,
  t1.first_name AS first_name_7,
  t1.last_name AS last_name_8,
  t1.language AS language_9,
  t1.blocked_until AS blocked_until_10,
  t1.block_scope AS block_scope_11,
  t1.created_at AS created_at_12,
  t1.updated_at AS updated_at_13,
  t1.last_login_at AS last_login_at_14,
  t1.last_activity_at AS last_activity_at_15,
  t1.previous_activity_at AS previous_activity_at_16,
  t1.returned_at AS returned_at_17,
  t1.last_activity AS last_activity_18,
  t1.deleted_at AS deleted_at_19,
  t1.credentials_changed_at AS credentials_changed_at_20,
  t0.password AS password_21,
  t0.permissions AS permissions_22,
  t0.sponsor_id AS sponsor_id_23,
  t1.role
FROM
  manager t0
  INNER JOIN user t1 ON t0.id = t1.id
  INNER JOIN campaign_manager ON t0.id = campaign_manager.manager_id
WHERE
  campaign_manager.campaign_id = ?

SELECT t1.id AS id_2, t1.status AS status_3, t1.email AS email_4, t1.pending_email AS pending_email_5, t1.phone_number AS phone_number_6, t1.first_name AS first_name_7, t1.last_name AS last_name_8, t1.language AS language_9, t1.blocked_until AS blocked_until_10, t1.block_scope AS block_scope_11, t1.created_at AS created_at_12, t1.updated_at AS updated_at_13, t1.last_login_at AS last_login_at_14, t1.last_activity_at AS last_activity_at_15, t1.previous_activity_at AS previous_activity_at_16, t1.returned_at AS returned_at_17, t1.last_activity AS last_activity_18, t1.deleted_at AS deleted_at_19, t1.credentials_changed_at AS credentials_changed_at_20, t0.password AS password_21, t0.permissions AS permissions_22, t0.sponsor_id AS sponsor_id_23, t1.role FROM manager t0 INNER JOIN user t1 ON t0.id = t1.id INNER JOIN campaign_manager ON t0.id = campaign_manager.manager_id WHERE campaign_manager.campaign_id = 17256;

SELECT
  t0.permission AS permission_1,
  t0.services_enabled AS services_enabled_2,
  t0.reported_at AS reported_at_3,
  t0.id AS id_4
FROM
  user_location_permission t0
WHERE
  t0.id = ?

SELECT t0.permission AS permission_1, t0.services_enabled AS services_enabled_2, t0.reported_at AS reported_at_3, t0.id AS id_4 FROM user_location_permission t0 WHERE t0.id = 2678414;

SELECT
  t0.value AS value_1,
  t0.changed_at AS changed_at_2,
  t0.id AS id_3
FROM
  payment_balance t0
WHERE
  t0.id = ?

SELECT t0.value AS value_1, t0.changed_at AS changed_at_2, t0.id AS id_3 FROM payment_balance t0 WHERE t0.id = 2678414;

SELECT
  t0.code AS code_1,
  t0.is_enabled AS is_enabled_2,
  t0.duration_days_per_referred_user AS duration_days_per_referred_user_3,
  t0.referred_by_ended_at AS referred_by_ended_at_4,
  t0.referral_activity_commission_percent AS referral_activity_commission_percent_5,
  t0.referral_new_campaign_commission_percent AS referral_new_campaign_commission_percent_6,
  t0.balance AS balance_7,
  t0.id AS id_8,
  t0.referred_by_id AS referred_by_id_9
FROM
  referral t0
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.is_enabled AS is_enabled_2, t0.duration_days_per_referred_user AS duration_days_per_referred_user_3, t0.referred_by_ended_at AS referred_by_ended_at_4, t0.referral_activity_commission_percent AS referral_activity_commission_percent_5, t0.referral_new_campaign_commission_percent AS referral_new_campaign_commission_percent_6, t0.balance AS balance_7, t0.id AS id_8, t0.referred_by_id AS referred_by_id_9 FROM referral t0 WHERE t0.id = 2678414;