Symfony Profiler

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

SELECT
  t0.subscribers AS subscribers_1,
  t0.viewers AS viewers_2,
  t0.genders_by_subscribers AS genders_by_subscribers_3,
  t0.genders_by_viewers AS genders_by_viewers_4,
  t0.ages_by_subscribers AS ages_by_subscribers_5,
  t0.ages_by_viewers AS ages_by_viewers_6,
  t0.locations_by_subscribers AS locations_by_subscribers_7,
  t0.locations_by_viewers AS locations_by_viewers_8,
  t0.id AS id_9
FROM
  analytics_creators_data t0
WHERE
  t0.id = ?

SELECT t0.subscribers AS subscribers_1, t0.viewers AS viewers_2, t0.genders_by_subscribers AS genders_by_subscribers_3, t0.genders_by_viewers AS genders_by_viewers_4, t0.ages_by_subscribers AS ages_by_subscribers_5, t0.ages_by_viewers AS ages_by_viewers_6, t0.locations_by_subscribers AS locations_by_subscribers_7, t0.locations_by_viewers AS locations_by_viewers_8, t0.id AS id_9 FROM analytics_creators_data t0 WHERE t0.id = 2676755;

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.referred_by_commission_percent AS referred_by_commission_percent_5,
  t0.agency_joined_at AS agency_joined_at_6,
  t0.referral_activity_commission_percent AS referral_activity_commission_percent_7,
  t0.referral_new_campaign_commission_percent AS referral_new_campaign_commission_percent_8,
  t0.reward_block_reason AS reward_block_reason_9,
  t0.referral_tail_commission_percent AS referral_tail_commission_percent_10,
  t0.referral_tail_duration_days AS referral_tail_duration_days_11,
  t0.balance AS balance_12,
  t0.id AS id_13,
  t0.referred_by_id AS referred_by_id_14
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.referred_by_commission_percent AS referred_by_commission_percent_5, t0.agency_joined_at AS agency_joined_at_6, t0.referral_activity_commission_percent AS referral_activity_commission_percent_7, t0.referral_new_campaign_commission_percent AS referral_new_campaign_commission_percent_8, t0.reward_block_reason AS reward_block_reason_9, t0.referral_tail_commission_percent AS referral_tail_commission_percent_10, t0.referral_tail_duration_days AS referral_tail_duration_days_11, t0.balance AS balance_12, t0.id AS id_13, t0.referred_by_id AS referred_by_id_14 FROM referral t0 WHERE t0.id = 2676755;

SELECT
  u0_.id AS id_0,
  u0_.status AS status_1,
  u0_.user_type AS user_type_2,
  u0_.email AS email_3,
  u0_.pending_email AS pending_email_4,
  u0_.phone_number AS phone_number_5,
  u0_.first_name AS first_name_6,
  u0_.last_name AS last_name_7,
  u0_.language AS language_8,
  u0_.blocked_until AS blocked_until_9,
  u0_.block_scope AS block_scope_10,
  u0_.message_violation_blocked_at AS message_violation_blocked_at_11,
  u0_.message_violation_block_reason AS message_violation_block_reason_12,
  u0_.message_violation_count AS message_violation_count_13,
  u0_.created_at AS created_at_14,
  u0_.updated_at AS updated_at_15,
  u0_.last_login_at AS last_login_at_16,
  u0_.last_activity_at AS last_activity_at_17,
  u0_.previous_activity_at AS previous_activity_at_18,
  u0_.returned_at AS returned_at_19,
  u0_.last_activity AS last_activity_20,
  u0_.deleted_at AS deleted_at_21,
  u0_.credentials_changed_at AS credentials_changed_at_22,
  c1_.platform AS platform_23,
  c1_.username AS username_24,
  c1_.gender AS gender_25,
  c1_.birthday AS birthday_26,
  c1_.minimal_amount AS minimal_amount_27,
  c1_.minimal_vip_amount AS minimal_vip_amount_28,
  c1_.followers AS followers_29,
  c1_.likes AS likes_30,
  c1_.average_views AS average_views_31,
  c1_.engagement_rate AS engagement_rate_32,
  c1_.average_views_coeff AS average_views_coeff_33,
  c1_.best_recent_views AS best_recent_views_34,
  c1_.videos AS videos_35,
  c1_.avg_pay_per_campaign AS avg_pay_per_campaign_36,
  c1_.paid_campaigns AS paid_campaigns_37,
  c1_.tier AS tier_38,
  c1_.ethnicity AS ethnicity_39,
  c1_.category_gender AS category_gender_40,
  c1_.age_group AS age_group_41,
  c1_.category_parent AS category_parent_42,
  c1_.attractiveness_level AS attractiveness_level_43,
  c1_.phone_notify_campaigns AS phone_notify_campaigns_44,
  c1_.email_notify_campaigns AS email_notify_campaigns_45,
  c1_.email_notify_newsletter AS email_notify_newsletter_46,
  c1_.vip AS vip_47,
  c1_.vip_multiplier AS vip_multiplier_48,
  c1_.strikes AS strikes_49,
  c1_.vip_revoked_at AS vip_revoked_at_50,
  c1_.select_program AS select_program_51,
  c1_.select_program_added_at AS select_program_added_at_52,
  c1_.select_program_revoked_at AS select_program_revoked_at_53,
  c1_.dark_theme AS dark_theme_54,
  c1_.is_survey_required AS is_survey_required_55,
  c1_.is_active AS is_active_56,
  c1_.shadow_banned_at AS shadow_banned_at_57,
  c1_.shadow_ban_reason AS shadow_ban_reason_58,
  c1_.shadow_banned_by_user_id AS shadow_banned_by_user_id_59,
  c1_.locked_tik_tok_union_id AS locked_tik_tok_union_id_60,
  c1_.locked_at AS locked_at_61,
  c1_.bio AS bio_62,
  c1_.facebook AS facebook_63,
  c1_.youtube AS youtube_64,
  c1_.instagram AS instagram_65,
  c1_.twitter AS twitter_66,
  c1_.cover AS cover_67,
  c1_.profile_picture_url AS profile_picture_url_68,
  c1_.paypal_id AS paypal_id_69,
  c1_.clipper_rules_accepted_at AS clipper_rules_accepted_at_70,
  c1_.tik_tok_id AS tik_tok_id_71,
  c1_.last_notifications AS last_notifications_72,
  c1_.updates AS updates_73,
  c1_.last_active_at AS last_active_at_74,
  c1_.scraped_at AS scraped_at_75,
  c1_.video_scraped_at AS video_scraped_at_76,
  c1_.classification_requested_at AS classification_requested_at_77,
  c1_.can_change_country AS can_change_country_78,
  c1_.country_source AS country_source_79,
  c1_.skipped_at AS skipped_at_80,
  c1_.verified_at AS verified_at_81,
  c1_.min_flat_fee AS min_flat_fee_82,
  c1_.is_show_less_than_flat_fee AS is_show_less_than_flat_fee_83,
  c1_.personal_rate AS personal_rate_84,
  c1_.personal_rate_approved_at AS personal_rate_approved_at_85,
  c1_.personal_rate_revoked_at AS personal_rate_revoked_at_86,
  c1_.vip_sale_percent AS vip_sale_percent_87,
  c1_.vip_sale_starts_at AS vip_sale_starts_at_88,
  c1_.vip_sale_ends_at AS vip_sale_ends_at_89,
  c1_.personal_rate_changed_at AS personal_rate_changed_at_90,
  c1_.personal_rate_previous AS personal_rate_previous_91,
  c1_.personal_rate_self_set AS personal_rate_self_set_92,
  c1_.rating_avg AS rating_avg_93,
  c1_.rating_count AS rating_count_94,
  c1_.rating_band AS rating_band_95,
  c1_.stripe_id AS stripe_id_96,
  c1_.password AS password_97,
  c1_.stripe_connected AS stripe_connected_98,
  t2_.id AS id_99,
  t2_.union_id AS union_id_100,
  t2_.access_token AS access_token_101,
  t2_.refresh_token AS refresh_token_102,
  t2_.refreshed_at AS refreshed_at_103,
  t2_.refresh_expires_at AS refresh_expires_at_104,
  t2_.needs_reconnect AS needs_reconnect_105,
  t2_.refresh_failed_at AS refresh_failed_at_106,
  t2_.access_token_expires_at AS access_token_expires_at_107,
  t2_.reconnect_email_sent_at AS reconnect_email_sent_at_108,
  i3_.id AS id_109,
  i3_.ig_id AS ig_id_110,
  i3_.access_token AS access_token_111,
  i3_.auth_provider AS auth_provider_112,
  i3_.refreshed_at AS refreshed_at_113,
  i3_.expires_at AS expires_at_114,
  i3_.created_at AS created_at_115,
  y4_.id AS id_116,
  y4_.channel_id AS channel_id_117,
  y4_.access_token AS access_token_118,
  y4_.refresh_token AS refresh_token_119,
  y4_.scope AS scope_120,
  y4_.token_type AS token_type_121,
  y4_.expired_in AS expired_in_122,
  y4_.created_at AS created_at_123,
  u0_.role AS role_124,
  c1_.tik_tok_auth_id AS tik_tok_auth_id_125,
  c1_.instagram_auth_id AS instagram_auth_id_126,
  c1_.youtube_auth_id AS youtube_auth_id_127,
  c1_.geolocation_id AS geolocation_id_128,
  c1_.country_id AS country_id_129,
  c1_.initially_country_id AS initially_country_id_130,
  c1_.user_id AS user_id_131
FROM
  creator c1_
  INNER JOIN user u0_ ON c1_.id = u0_.id
  LEFT JOIN tik_tok_auth t2_ ON c1_.tik_tok_auth_id = t2_.id
  LEFT JOIN instagram_auth i3_ ON c1_.instagram_auth_id = i3_.id
  LEFT JOIN youtube_auth y4_ ON c1_.youtube_auth_id = y4_.id
WHERE
  c1_.user_id = ?
  OR (
    (
      u0_.id = ?
      AND c1_.user_id IS NULL
    )
  )

SELECT u0_.id AS id_0, u0_.status AS status_1, u0_.user_type AS user_type_2, u0_.email AS email_3, u0_.pending_email AS pending_email_4, u0_.phone_number AS phone_number_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.language AS language_8, u0_.blocked_until AS blocked_until_9, u0_.block_scope AS block_scope_10, u0_.message_violation_blocked_at AS message_violation_blocked_at_11, u0_.message_violation_block_reason AS message_violation_block_reason_12, u0_.message_violation_count AS message_violation_count_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.last_login_at AS last_login_at_16, u0_.last_activity_at AS last_activity_at_17, u0_.previous_activity_at AS previous_activity_at_18, u0_.returned_at AS returned_at_19, u0_.last_activity AS last_activity_20, u0_.deleted_at AS deleted_at_21, u0_.credentials_changed_at AS credentials_changed_at_22, c1_.platform AS platform_23, c1_.username AS username_24, c1_.gender AS gender_25, c1_.birthday AS birthday_26, c1_.minimal_amount AS minimal_amount_27, c1_.minimal_vip_amount AS minimal_vip_amount_28, c1_.followers AS followers_29, c1_.likes AS likes_30, c1_.average_views AS average_views_31, c1_.engagement_rate AS engagement_rate_32, c1_.average_views_coeff AS average_views_coeff_33, c1_.best_recent_views AS best_recent_views_34, c1_.videos AS videos_35, c1_.avg_pay_per_campaign AS avg_pay_per_campaign_36, c1_.paid_campaigns AS paid_campaigns_37, c1_.tier AS tier_38, c1_.ethnicity AS ethnicity_39, c1_.category_gender AS category_gender_40, c1_.age_group AS age_group_41, c1_.category_parent AS category_parent_42, c1_.attractiveness_level AS attractiveness_level_43, c1_.phone_notify_campaigns AS phone_notify_campaigns_44, c1_.email_notify_campaigns AS email_notify_campaigns_45, c1_.email_notify_newsletter AS email_notify_newsletter_46, c1_.vip AS vip_47, c1_.vip_multiplier AS vip_multiplier_48, c1_.strikes AS strikes_49, c1_.vip_revoked_at AS vip_revoked_at_50, c1_.select_program AS select_program_51, c1_.select_program_added_at AS select_program_added_at_52, c1_.select_program_revoked_at AS select_program_revoked_at_53, c1_.dark_theme AS dark_theme_54, c1_.is_survey_required AS is_survey_required_55, c1_.is_active AS is_active_56, c1_.shadow_banned_at AS shadow_banned_at_57, c1_.shadow_ban_reason AS shadow_ban_reason_58, c1_.shadow_banned_by_user_id AS shadow_banned_by_user_id_59, c1_.locked_tik_tok_union_id AS locked_tik_tok_union_id_60, c1_.locked_at AS locked_at_61, c1_.bio AS bio_62, c1_.facebook AS facebook_63, c1_.youtube AS youtube_64, c1_.instagram AS instagram_65, c1_.twitter AS twitter_66, c1_.cover AS cover_67, c1_.profile_picture_url AS profile_picture_url_68, c1_.paypal_id AS paypal_id_69, c1_.clipper_rules_accepted_at AS clipper_rules_accepted_at_70, c1_.tik_tok_id AS tik_tok_id_71, c1_.last_notifications AS last_notifications_72, c1_.updates AS updates_73, c1_.last_active_at AS last_active_at_74, c1_.scraped_at AS scraped_at_75, c1_.video_scraped_at AS video_scraped_at_76, c1_.classification_requested_at AS classification_requested_at_77, c1_.can_change_country AS can_change_country_78, c1_.country_source AS country_source_79, c1_.skipped_at AS skipped_at_80, c1_.verified_at AS verified_at_81, c1_.min_flat_fee AS min_flat_fee_82, c1_.is_show_less_than_flat_fee AS is_show_less_than_flat_fee_83, c1_.personal_rate AS personal_rate_84, c1_.personal_rate_approved_at AS personal_rate_approved_at_85, c1_.personal_rate_revoked_at AS personal_rate_revoked_at_86, c1_.vip_sale_percent AS vip_sale_percent_87, c1_.vip_sale_starts_at AS vip_sale_starts_at_88, c1_.vip_sale_ends_at AS vip_sale_ends_at_89, c1_.personal_rate_changed_at AS personal_rate_changed_at_90, c1_.personal_rate_previous AS personal_rate_previous_91, c1_.personal_rate_self_set AS personal_rate_self_set_92, c1_.rating_avg AS rating_avg_93, c1_.rating_count AS rating_count_94, c1_.rating_band AS rating_band_95, c1_.stripe_id AS stripe_id_96, c1_.password AS password_97, c1_.stripe_connected AS stripe_connected_98, t2_.id AS id_99, t2_.union_id AS union_id_100, t2_.access_token AS access_token_101, t2_.refresh_token AS refresh_token_102, t2_.refreshed_at AS refreshed_at_103, t2_.refresh_expires_at AS refresh_expires_at_104, t2_.needs_reconnect AS needs_reconnect_105, t2_.refresh_failed_at AS refresh_failed_at_106, t2_.access_token_expires_at AS access_token_expires_at_107, t2_.reconnect_email_sent_at AS reconnect_email_sent_at_108, i3_.id AS id_109, i3_.ig_id AS ig_id_110, i3_.access_token AS access_token_111, i3_.auth_provider AS auth_provider_112, i3_.refreshed_at AS refreshed_at_113, i3_.expires_at AS expires_at_114, i3_.created_at AS created_at_115, y4_.id AS id_116, y4_.channel_id AS channel_id_117, y4_.access_token AS access_token_118, y4_.refresh_token AS refresh_token_119, y4_.scope AS scope_120, y4_.token_type AS token_type_121, y4_.expired_in AS expired_in_122, y4_.created_at AS created_at_123, u0_.role AS role_124, c1_.tik_tok_auth_id AS tik_tok_auth_id_125, c1_.instagram_auth_id AS instagram_auth_id_126, c1_.youtube_auth_id AS youtube_auth_id_127, c1_.geolocation_id AS geolocation_id_128, c1_.country_id AS country_id_129, c1_.initially_country_id AS initially_country_id_130, c1_.user_id AS user_id_131 FROM creator c1_ INNER JOIN user u0_ ON c1_.id = u0_.id LEFT JOIN tik_tok_auth t2_ ON c1_.tik_tok_auth_id = t2_.id LEFT JOIN instagram_auth i3_ ON c1_.instagram_auth_id = i3_.id LEFT JOIN youtube_auth y4_ ON c1_.youtube_auth_id = y4_.id WHERE c1_.user_id = '2676755' OR ((u0_.id = 2676755 AND c1_.user_id IS NULL));

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

SELECT
  t1.id AS id_2,
  t1.status AS status_3,
  t1.user_type AS user_type_4,
  t1.email AS email_5,
  t1.pending_email AS pending_email_6,
  t1.phone_number AS phone_number_7,
  t1.first_name AS first_name_8,
  t1.last_name AS last_name_9,
  t1.language AS language_10,
  t1.blocked_until AS blocked_until_11,
  t1.block_scope AS block_scope_12,
  t1.message_violation_blocked_at AS message_violation_blocked_at_13,
  t1.message_violation_block_reason AS message_violation_block_reason_14,
  t1.message_violation_count AS message_violation_count_15,
  t1.created_at AS created_at_16,
  t1.updated_at AS updated_at_17,
  t1.last_login_at AS last_login_at_18,
  t1.last_activity_at AS last_activity_at_19,
  t1.previous_activity_at AS previous_activity_at_20,
  t1.returned_at AS returned_at_21,
  t1.last_activity AS last_activity_22,
  t1.deleted_at AS deleted_at_23,
  t1.credentials_changed_at AS credentials_changed_at_24,
  t0.platform AS platform_25,
  t0.username AS username_26,
  t0.gender AS gender_27,
  t0.birthday AS birthday_28,
  t0.minimal_amount AS minimal_amount_29,
  t0.minimal_vip_amount AS minimal_vip_amount_30,
  t0.followers AS followers_31,
  t0.likes AS likes_32,
  t0.average_views AS average_views_33,
  t0.engagement_rate AS engagement_rate_34,
  t0.average_views_coeff AS average_views_coeff_35,
  t0.best_recent_views AS best_recent_views_36,
  t0.videos AS videos_37,
  t0.avg_pay_per_campaign AS avg_pay_per_campaign_38,
  t0.paid_campaigns AS paid_campaigns_39,
  t0.tier AS tier_40,
  t0.ethnicity AS ethnicity_41,
  t0.category_gender AS category_gender_42,
  t0.age_group AS age_group_43,
  t0.category_parent AS category_parent_44,
  t0.attractiveness_level AS attractiveness_level_45,
  t0.phone_notify_campaigns AS phone_notify_campaigns_46,
  t0.email_notify_campaigns AS email_notify_campaigns_47,
  t0.email_notify_newsletter AS email_notify_newsletter_48,
  t0.vip AS vip_49,
  t0.vip_multiplier AS vip_multiplier_50,
  t0.strikes AS strikes_51,
  t0.vip_revoked_at AS vip_revoked_at_52,
  t0.select_program AS select_program_53,
  t0.select_program_added_at AS select_program_added_at_54,
  t0.select_program_revoked_at AS select_program_revoked_at_55,
  t0.dark_theme AS dark_theme_56,
  t0.is_survey_required AS is_survey_required_57,
  t0.is_active AS is_active_58,
  t0.shadow_banned_at AS shadow_banned_at_59,
  t0.shadow_ban_reason AS shadow_ban_reason_60,
  t0.shadow_banned_by_user_id AS shadow_banned_by_user_id_61,
  t0.locked_tik_tok_union_id AS locked_tik_tok_union_id_62,
  t0.locked_at AS locked_at_63,
  t0.bio AS bio_64,
  t0.facebook AS facebook_65,
  t0.youtube AS youtube_66,
  t0.instagram AS instagram_67,
  t0.twitter AS twitter_68,
  t0.cover AS cover_69,
  t0.profile_picture_url AS profile_picture_url_70,
  t0.paypal_id AS paypal_id_71,
  t0.clipper_rules_accepted_at AS clipper_rules_accepted_at_72,
  t0.tik_tok_id AS tik_tok_id_73,
  t0.last_notifications AS last_notifications_74,
  t0.updates AS updates_75,
  t0.last_active_at AS last_active_at_76,
  t0.scraped_at AS scraped_at_77,
  t0.video_scraped_at AS video_scraped_at_78,
  t0.classification_requested_at AS classification_requested_at_79,
  t0.can_change_country AS can_change_country_80,
  t0.country_source AS country_source_81,
  t0.skipped_at AS skipped_at_82,
  t0.verified_at AS verified_at_83,
  t0.min_flat_fee AS min_flat_fee_84,
  t0.is_show_less_than_flat_fee AS is_show_less_than_flat_fee_85,
  t0.personal_rate AS personal_rate_86,
  t0.personal_rate_approved_at AS personal_rate_approved_at_87,
  t0.personal_rate_revoked_at AS personal_rate_revoked_at_88,
  t0.vip_sale_percent AS vip_sale_percent_89,
  t0.vip_sale_starts_at AS vip_sale_starts_at_90,
  t0.vip_sale_ends_at AS vip_sale_ends_at_91,
  t0.personal_rate_changed_at AS personal_rate_changed_at_92,
  t0.personal_rate_previous AS personal_rate_previous_93,
  t0.personal_rate_self_set AS personal_rate_self_set_94,
  t0.rating_avg AS rating_avg_95,
  t0.rating_count AS rating_count_96,
  t0.rating_band AS rating_band_97,
  t0.stripe_id AS stripe_id_98,
  t0.password AS password_99,
  t0.stripe_connected AS stripe_connected_100,
  t0.tik_tok_auth_id AS tik_tok_auth_id_101,
  t0.instagram_auth_id AS instagram_auth_id_102,
  t0.youtube_auth_id AS youtube_auth_id_103,
  t0.geolocation_id AS geolocation_id_104,
  t0.country_id AS country_id_105,
  t0.initially_country_id AS initially_country_id_106,
  t0.user_id AS user_id_107,
  t1.role
FROM
  creator 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.user_type AS user_type_4, t1.email AS email_5, t1.pending_email AS pending_email_6, t1.phone_number AS phone_number_7, t1.first_name AS first_name_8, t1.last_name AS last_name_9, t1.language AS language_10, t1.blocked_until AS blocked_until_11, t1.block_scope AS block_scope_12, t1.message_violation_blocked_at AS message_violation_blocked_at_13, t1.message_violation_block_reason AS message_violation_block_reason_14, t1.message_violation_count AS message_violation_count_15, t1.created_at AS created_at_16, t1.updated_at AS updated_at_17, t1.last_login_at AS last_login_at_18, t1.last_activity_at AS last_activity_at_19, t1.previous_activity_at AS previous_activity_at_20, t1.returned_at AS returned_at_21, t1.last_activity AS last_activity_22, t1.deleted_at AS deleted_at_23, t1.credentials_changed_at AS credentials_changed_at_24, t0.platform AS platform_25, t0.username AS username_26, t0.gender AS gender_27, t0.birthday AS birthday_28, t0.minimal_amount AS minimal_amount_29, t0.minimal_vip_amount AS minimal_vip_amount_30, t0.followers AS followers_31, t0.likes AS likes_32, t0.average_views AS average_views_33, t0.engagement_rate AS engagement_rate_34, t0.average_views_coeff AS average_views_coeff_35, t0.best_recent_views AS best_recent_views_36, t0.videos AS videos_37, t0.avg_pay_per_campaign AS avg_pay_per_campaign_38, t0.paid_campaigns AS paid_campaigns_39, t0.tier AS tier_40, t0.ethnicity AS ethnicity_41, t0.category_gender AS category_gender_42, t0.age_group AS age_group_43, t0.category_parent AS category_parent_44, t0.attractiveness_level AS attractiveness_level_45, t0.phone_notify_campaigns AS phone_notify_campaigns_46, t0.email_notify_campaigns AS email_notify_campaigns_47, t0.email_notify_newsletter AS email_notify_newsletter_48, t0.vip AS vip_49, t0.vip_multiplier AS vip_multiplier_50, t0.strikes AS strikes_51, t0.vip_revoked_at AS vip_revoked_at_52, t0.select_program AS select_program_53, t0.select_program_added_at AS select_program_added_at_54, t0.select_program_revoked_at AS select_program_revoked_at_55, t0.dark_theme AS dark_theme_56, t0.is_survey_required AS is_survey_required_57, t0.is_active AS is_active_58, t0.shadow_banned_at AS shadow_banned_at_59, t0.shadow_ban_reason AS shadow_ban_reason_60, t0.shadow_banned_by_user_id AS shadow_banned_by_user_id_61, t0.locked_tik_tok_union_id AS locked_tik_tok_union_id_62, t0.locked_at AS locked_at_63, t0.bio AS bio_64, t0.facebook AS facebook_65, t0.youtube AS youtube_66, t0.instagram AS instagram_67, t0.twitter AS twitter_68, t0.cover AS cover_69, t0.profile_picture_url AS profile_picture_url_70, t0.paypal_id AS paypal_id_71, t0.clipper_rules_accepted_at AS clipper_rules_accepted_at_72, t0.tik_tok_id AS tik_tok_id_73, t0.last_notifications AS last_notifications_74, t0.updates AS updates_75, t0.last_active_at AS last_active_at_76, t0.scraped_at AS scraped_at_77, t0.video_scraped_at AS video_scraped_at_78, t0.classification_requested_at AS classification_requested_at_79, t0.can_change_country AS can_change_country_80, t0.country_source AS country_source_81, t0.skipped_at AS skipped_at_82, t0.verified_at AS verified_at_83, t0.min_flat_fee AS min_flat_fee_84, t0.is_show_less_than_flat_fee AS is_show_less_than_flat_fee_85, t0.personal_rate AS personal_rate_86, t0.personal_rate_approved_at AS personal_rate_approved_at_87, t0.personal_rate_revoked_at AS personal_rate_revoked_at_88, t0.vip_sale_percent AS vip_sale_percent_89, t0.vip_sale_starts_at AS vip_sale_starts_at_90, t0.vip_sale_ends_at AS vip_sale_ends_at_91, t0.personal_rate_changed_at AS personal_rate_changed_at_92, t0.personal_rate_previous AS personal_rate_previous_93, t0.personal_rate_self_set AS personal_rate_self_set_94, t0.rating_avg AS rating_avg_95, t0.rating_count AS rating_count_96, t0.rating_band AS rating_band_97, t0.stripe_id AS stripe_id_98, t0.password AS password_99, t0.stripe_connected AS stripe_connected_100, t0.tik_tok_auth_id AS tik_tok_auth_id_101, t0.instagram_auth_id AS instagram_auth_id_102, t0.youtube_auth_id AS youtube_auth_id_103, t0.geolocation_id AS geolocation_id_104, t0.country_id AS country_id_105, t0.initially_country_id AS initially_country_id_106, t0.user_id AS user_id_107, t1.role FROM creator t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = 2676755;

SELECT
  COALESCE(
    SUM(c0_.creator_unread_count),
    0
  ) AS sclr_0
FROM
  conversation c0_
WHERE
  c0_.creator_id IN (?, ?, ?)

SELECT COALESCE(SUM(c0_.creator_unread_count), 0) AS sclr_0 FROM conversation c0_ WHERE c0_.creator_id IN ('2676755', '2676756', '2676757');