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
  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,
  m1_.password AS password_19,
  m1_.permissions AS permissions_20,
  u0_.role AS role_21,
  m1_.sponsor_id AS sponsor_id_22
FROM
  manager m1_
  INNER JOIN user u0_ ON m1_.id = u0_.id
WHERE
  m1_.sponsor_id IN (?, ?)
ORDER BY
  u0_.first_name ASC

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, m1_.password AS password_19, m1_.permissions AS permissions_20, u0_.role AS role_21, m1_.sponsor_id AS sponsor_id_22 FROM manager m1_ INNER JOIN user u0_ ON m1_.id = u0_.id WHERE m1_.sponsor_id IN ('2667810', '2678429') ORDER BY u0_.first_name ASC;

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

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

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

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;