Symfony Profiler

Query Metrics

20 Database Queries

12 Different statements

15.81 ms Query time

5 Invalid entities

18 Managed entities

Queries


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 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.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.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.reward_block_reason AS reward_block_reason_7, t0.referral_tail_commission_percent AS referral_tail_commission_percent_8, t0.referral_tail_duration_days AS referral_tail_duration_days_9, t0.balance AS balance_10, t0.id AS id_11, t0.referred_by_id AS referred_by_id_12 FROM referral 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 = ?
SELECT t0.id AS id_1, t0.status AS status_2, t0.last_message_at AS last_message_at_3, t0.sponsor_unread_count AS sponsor_unread_count_4, t0.creator_unread_count AS creator_unread_count_5, t0.created_at AS created_at_6, t0.opened_by_user_id AS opened_by_user_id_7, t0.activity_id AS activity_id_8, t0.campaign_id AS campaign_id_9, t0.creator_id AS creator_id_10, t0.sponsor_id AS sponsor_id_11 FROM conversation t0 WHERE t0.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 = ?
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.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.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.reward_block_reason AS reward_block_reason_7, t0.referral_tail_commission_percent AS referral_tail_commission_percent_8, t0.referral_tail_duration_days AS referral_tail_duration_days_9, t0.balance AS balance_10, t0.id AS id_11, t0.referred_by_id AS referred_by_id_12 FROM referral 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 = ?
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.boost_spent AS boost_spent_21, t0.boost_schedule_start AS boost_schedule_start_22, t0.boost_schedule_end AS boost_schedule_end_23, t0.boost_schedule_deadline AS boost_schedule_deadline_24, t0.boost_schedule_base AS boost_schedule_base_25, t0.boost_schedule_pot AS boost_schedule_pot_26, t0.starter_offer AS starter_offer_27, t0.bonus AS bonus_28, t0.paid AS paid_29, t0.reserved AS reserved_30, t0.upsell_amount AS upsell_amount_31, t0.upsell_reserved AS upsell_reserved_32, t0.upsell_paid AS upsell_paid_33, t0.deadline_extension_count AS deadline_extension_count_34, t0.min_views_per_video AS min_views_per_video_35, t0.max_views_per_video AS max_views_per_video_36, t0.min_follower_count AS min_follower_count_37, t0.max_follower_count AS max_follower_count_38, t0.min_video_count AS min_video_count_39, t0.max_video_count AS max_video_count_40, t0.min_like_count AS min_like_count_41, t0.max_like_count AS max_like_count_42, t0.age_from AS age_from_43, t0.age_to AS age_to_44, t0.direction AS direction_45, t0.flat_price AS flat_price_46, t0.vip_creator AS vip_creator_47, t0.is_clipping AS is_clipping_48, t0.clip_cpm AS clip_cpm_49, t0.clip_platforms AS clip_platforms_50, t0.clip_sounds AS clip_sounds_51, t0.verified_creator AS verified_creator_52, t0.unverified_creator AS unverified_creator_53, t0.creator_geolocation_enabled AS creator_geolocation_enabled_54, t0.creator_geolocation_disabled AS creator_geolocation_disabled_55, t0.skipped_creator AS skipped_creator_56, t0.non_skipped_creator AS non_skipped_creator_57, t0.max_price_per_video AS max_price_per_video_58, t0.automatically_apply AS automatically_apply_59, t0.automatically_pay AS automatically_pay_60, t0.hide_audio AS hide_audio_61, t0.discovery_slice_enabled AS discovery_slice_enabled_62, t0.discovery_slice_percent AS discovery_slice_percent_63, t0.surge_percent AS surge_percent_64, t0.surge_ends_at AS surge_ends_at_65, t0.creator_approval_mode AS creator_approval_mode_66, t0.creator_approval_window_ends_at AS creator_approval_window_ends_at_67, t0.stat_pending AS stat_pending_68, t0.stat_creators AS stat_creators_69, t0.stat_videos AS stat_videos_70, t0.stat_views AS stat_views_71, t0.stat_likes AS stat_likes_72, t0.stat_comments AS stat_comments_73, t0.stat_shares AS stat_shares_74, t0.stat_followers AS stat_followers_75, t0.deadline_at AS deadline_at_76, t0.created_at AS created_at_77, t0.updated_at AS updated_at_78, t0.payed_at AS payed_at_79, t0.completed_at AS completed_at_80, t0.retention_checked_at AS retention_checked_at_81, t0.activated_at AS activated_at_82, t0.survey_targeting AS survey_targeting_83, t0.content_languages AS content_languages_84, t0.creator_communities AS creator_communities_85, t0.niche_semantic_matches AS niche_semantic_matches_86, t0.niche_semantic_buckets AS niche_semantic_buckets_87, t0.niches AS niches_88, t0.purchase_order AS purchase_order_89, t0.purchase_order_status AS purchase_order_status_90, t0.notification_settings AS notification_settings_91, t0.accesses AS accesses_92, t0.goal AS goal_93, t0.min_engagment_rate AS min_engagment_rate_94, t0.max_engagment_rate AS max_engagment_rate_95, t0.is_show_draft AS is_show_draft_96, t0.is_contest AS is_contest_97, t0.autocomplete_schema AS autocomplete_schema_98, t0.inbox_paid_percent AS inbox_paid_percent_99, t0.analytics_targeting AS analytics_targeting_100, t0.other_sponsor_personal_bonus AS other_sponsor_personal_bonus_101, t0.money_returned AS money_returned_102, t0.desired_creator_link1 AS desired_creator_link1_103, t0.desired_creator_link2 AS desired_creator_link2_104, t0.desired_creator_link3 AS desired_creator_link3_105, t0.promise_creators_min AS promise_creators_min_106, t0.promise_creators_max AS promise_creators_max_107, t0.promise_views_min AS promise_views_min_108, t0.promise_views_max AS promise_views_max_109, t0.promise_budget AS promise_budget_110, t0.promise_captured_at AS promise_captured_at_111, t0.promise_source AS promise_source_112, t0.parent_campaign_id AS parent_campaign_id_113, t0.speed_id AS speed_id_114, t0.sponsor_id AS sponsor_id_115, t0.song_id AS song_id_116, t0.img AS img_117, t0.created_by_manager_id AS created_by_manager_id_118 FROM campaign t0 WHERE t0.id = ?
SELECT t0.lyrics AS lyrics_1, t0.transcribed_at AS transcribed_at_2, t0.audio_profile AS audio_profile_3, t0.audio_profiled_at AS audio_profiled_at_4, t0.id AS id_5, t0.name AS name_6, t0.artist AS artist_7, t0.url AS url_8, t0.external_id AS external_id_9, t0.file AS file_10, t0.image AS image_11, t0.created_at AS created_at_12 FROM song t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.curator_user_id AS curator_user_id_2, t0.curated_at AS curated_at_3, t0.video_review_at AS video_review_at_4, t0.clip_seq AS clip_seq_5, t0.resubmission_count AS resubmission_count_6, t0.boost_status AS boost_status_7, t0.boost_requested_by_admin AS boost_requested_by_admin_8, t0.draft_requested AS draft_requested_9, t0.status AS status_10, t0.amount AS amount_11, t0.cpm AS cpm_12, t0.paid AS paid_13, t0.personal_bonus AS personal_bonus_14, t0.followers AS followers_15, t0.averageViews AS averageViews_16, t0.vip_multiplier AS vip_multiplier_17, t0.reserved_amount AS reserved_amount_18, t0.verified_audience_pricing_v3 AS verified_audience_pricing_v3_19, t0.analytics_freshness_decay AS analytics_freshness_decay_20, t0.reason AS reason_21, t0.dispute_reason AS dispute_reason_22, t0.video_deadline_at AS video_deadline_at_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.payed_at AS payed_at_26, t0.video_removed_after_earning_at AS video_removed_after_earning_at_27, t0.video_removed_views AS video_removed_views_28, t0.video_removed_notified_at AS video_removed_notified_at_29, t0.upsell_status AS upsell_status_30, t0.upsell_asking_price AS upsell_asking_price_31, t0.upsell_sale_percent AS upsell_sale_percent_32, t0.upsell_list_price AS upsell_list_price_33, t0.upsell_approved_price AS upsell_approved_price_34, t0.upsell_platform_fee AS upsell_platform_fee_35, t0.shadow_ban_price AS shadow_ban_price_36, t0.shadow_ban_suggested_price AS shadow_ban_suggested_price_37, t0.negotiated_price_gross AS negotiated_price_gross_38, t0.negotiated_offer_id AS negotiated_offer_id_39, t0.upsell_charge_id AS upsell_charge_id_40, t0.upsell_refund_id AS upsell_refund_id_41, t0.upsell_approved_at AS upsell_approved_at_42, t0.upsell_refunded_at AS upsell_refunded_at_43, t0.upsell_attempt_token AS upsell_attempt_token_44, t0.personal_rate_net AS personal_rate_net_45, t0.personal_rate_cost_per_view AS personal_rate_cost_per_view_46, t0.personal_rate_median_views AS personal_rate_median_views_47, t0.personal_rate_commission_percent AS personal_rate_commission_percent_48, t0.personal_rate_curve AS personal_rate_curve_49, t0.personal_rate_algo_cost_per_view AS personal_rate_algo_cost_per_view_50, t0.rating_multiplier AS rating_multiplier_51, t0.boost_engagement_multiplier AS boost_engagement_multiplier_52, t0.surge_percent_applied AS surge_percent_applied_53, t0.creator_id AS creator_id_54, t0.campaign_id AS campaign_id_55, t0.video_id AS video_id_56, t0.declined_video_id AS declined_video_id_57, t0.complaint_id AS complaint_id_58 FROM activity t0 WHERE t0.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.password AS password_25, t0.company_name AS company_name_26, t0.company_website AS company_website_27, t0.job_title AS job_title_28, t0.country AS country_29, t0.about_us AS about_us_30, t0.promote AS promote_31, t0.credit AS credit_32, t0.with_payment_process AS with_payment_process_33, t0.has_creator_account AS has_creator_account_34, t0.notify_email AS notify_email_35, t0.notify_sms AS notify_sms_36, t0.credit_limit AS credit_limit_37, t0.used_credit AS used_credit_38, t0.store_credit AS store_credit_39, t0.permissions AS permissions_40, t0.total_creators AS total_creators_41, t0.total_videos AS total_videos_42, t0.total_views AS total_views_43, t0.total_price AS total_price_44, t0.referral_source AS referral_source_45, t0.referral_source_other AS referral_source_other_46, t0.paypal_id AS paypal_id_47, t0.starter_offer_expires_at AS starter_offer_expires_at_48, t0.referral_prompt_dismissed_at AS referral_prompt_dismissed_at_49, t0.referral_prompt_dismissals AS referral_prompt_dismissals_50, t1.role FROM sponsor t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.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 = ?
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.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.reward_block_reason AS reward_block_reason_7, t0.referral_tail_commission_percent AS referral_tail_commission_percent_8, t0.referral_tail_duration_days AS referral_tail_duration_days_9, t0.balance AS balance_10, t0.id AS id_11, t0.referred_by_id AS referred_by_id_12 FROM referral t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.amount AS amount_3, t0.hours AS hours_4, t0.percent AS percent_5 FROM speed t0 WHERE t0.id = ?
SELECT m0_.id AS id_0, m0_.sender_type AS sender_type_1, m0_.sender_user_id AS sender_user_id_2, m0_.kind AS kind_3, m0_.body AS body_4, m0_.moderation_verdict AS moderation_verdict_5, m0_.created_at AS created_at_6, m0_.review_status AS review_status_7, m0_.reviewed_at AS reviewed_at_8, m0_.reviewed_by_user_id AS reviewed_by_user_id_9, m0_.review_note AS review_note_10, o1_.id AS id_11, o1_.proposed_by AS proposed_by_12, o1_.proposed_by_user_id AS proposed_by_user_id_13, o1_.amount_gross AS amount_gross_14, o1_.currency AS currency_15, o1_.note AS note_16, o1_.status AS status_17, o1_.expires_at AS expires_at_18, o1_.decided_at AS decided_at_19, o1_.decided_by_user_id AS decided_by_user_id_20, o1_.supersedes_offer_id AS supersedes_offer_id_21, o1_.superseded_by_offer_id AS superseded_by_offer_id_22, o1_.created_at AS created_at_23, m0_.conversation_id AS conversation_id_24, m0_.offer_id AS offer_id_25, o1_.conversation_id AS conversation_id_26, o1_.activity_id AS activity_id_27 FROM message m0_ LEFT JOIN offer o1_ ON m0_.offer_id = o1_.id WHERE m0_.conversation_id = ? AND m0_.id > ? ORDER BY m0_.id ASC LIMIT 50

#▲	Time	Info
1	1.26 ms	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 = ? Parameters: [`2676755`] View formatted query View runnable query Explain query 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;
2	0.63 ms	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 = ? Parameters: [`2676755`] View formatted query View runnable query Explain query 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;
3	0.58 ms	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 = ? Parameters: [`2676755`] View formatted query View runnable query Explain query 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;
4	0.68 ms	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.reward_block_reason AS reward_block_reason_7, t0.referral_tail_commission_percent AS referral_tail_commission_percent_8, t0.referral_tail_duration_days AS referral_tail_duration_days_9, t0.balance AS balance_10, t0.id AS id_11, t0.referred_by_id AS referred_by_id_12 FROM referral t0 WHERE t0.id = ? Parameters: [`2676755`] View formatted query View runnable query Explain query 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.reward_block_reason AS reward_block_reason_7, t0.referral_tail_commission_percent AS referral_tail_commission_percent_8, t0.referral_tail_duration_days AS referral_tail_duration_days_9, t0.balance AS balance_10, t0.id AS id_11, t0.referred_by_id AS referred_by_id_12 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.reward_block_reason AS reward_block_reason_7, t0.referral_tail_commission_percent AS referral_tail_commission_percent_8, t0.referral_tail_duration_days AS referral_tail_duration_days_9, t0.balance AS balance_10, t0.id AS id_11, t0.referred_by_id AS referred_by_id_12 FROM referral t0 WHERE t0.id = 2676755;
5	1.09 ms	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 = ? Parameters: [`2676755`] View formatted query View runnable query Explain query 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;
6	0.84 ms	SELECT t0.id AS id_1, t0.status AS status_2, t0.last_message_at AS last_message_at_3, t0.sponsor_unread_count AS sponsor_unread_count_4, t0.creator_unread_count AS creator_unread_count_5, t0.created_at AS created_at_6, t0.opened_by_user_id AS opened_by_user_id_7, t0.activity_id AS activity_id_8, t0.campaign_id AS campaign_id_9, t0.creator_id AS creator_id_10, t0.sponsor_id AS sponsor_id_11 FROM conversation t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.status AS status_2, t0.last_message_at AS last_message_at_3, t0.sponsor_unread_count AS sponsor_unread_count_4, t0.creator_unread_count AS creator_unread_count_5, t0.created_at AS created_at_6, t0.opened_by_user_id AS opened_by_user_id_7, t0.activity_id AS activity_id_8, t0.campaign_id AS campaign_id_9, t0.creator_id AS creator_id_10, t0.sponsor_id AS sponsor_id_11 FROM conversation t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.status AS status_2, t0.last_message_at AS last_message_at_3, t0.sponsor_unread_count AS sponsor_unread_count_4, t0.creator_unread_count AS creator_unread_count_5, t0.created_at AS created_at_6, t0.opened_by_user_id AS opened_by_user_id_7, t0.activity_id AS activity_id_8, t0.campaign_id AS campaign_id_9, t0.creator_id AS creator_id_10, t0.sponsor_id AS sponsor_id_11 FROM conversation t0 WHERE t0.id = 1;
7	1.46 ms	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 = ? Parameters: [`2676756`] View formatted query View runnable query Explain query 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 = 2676756;
8	0.62 ms	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 = ? Parameters: [`2676756`] View formatted query View runnable query Explain query 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 = 2676756;
9	0.55 ms	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 = ? Parameters: [`2676756`] View formatted query View runnable query Explain query 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 = 2676756;
10	0.62 ms	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.reward_block_reason AS reward_block_reason_7, t0.referral_tail_commission_percent AS referral_tail_commission_percent_8, t0.referral_tail_duration_days AS referral_tail_duration_days_9, t0.balance AS balance_10, t0.id AS id_11, t0.referred_by_id AS referred_by_id_12 FROM referral t0 WHERE t0.id = ? Parameters: [`2676756`] View formatted query View runnable query Explain query 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.reward_block_reason AS reward_block_reason_7, t0.referral_tail_commission_percent AS referral_tail_commission_percent_8, t0.referral_tail_duration_days AS referral_tail_duration_days_9, t0.balance AS balance_10, t0.id AS id_11, t0.referred_by_id AS referred_by_id_12 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.reward_block_reason AS reward_block_reason_7, t0.referral_tail_commission_percent AS referral_tail_commission_percent_8, t0.referral_tail_duration_days AS referral_tail_duration_days_9, t0.balance AS balance_10, t0.id AS id_11, t0.referred_by_id AS referred_by_id_12 FROM referral t0 WHERE t0.id = 2676756;
11	0.65 ms	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 = ? Parameters: [`2676756`] View formatted query View runnable query Explain query 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 = 2676756;
12	1.23 ms	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.boost_spent AS boost_spent_21, t0.boost_schedule_start AS boost_schedule_start_22, t0.boost_schedule_end AS boost_schedule_end_23, t0.boost_schedule_deadline AS boost_schedule_deadline_24, t0.boost_schedule_base AS boost_schedule_base_25, t0.boost_schedule_pot AS boost_schedule_pot_26, t0.starter_offer AS starter_offer_27, t0.bonus AS bonus_28, t0.paid AS paid_29, t0.reserved AS reserved_30, t0.upsell_amount AS upsell_amount_31, t0.upsell_reserved AS upsell_reserved_32, t0.upsell_paid AS upsell_paid_33, t0.deadline_extension_count AS deadline_extension_count_34, t0.min_views_per_video AS min_views_per_video_35, t0.max_views_per_video AS max_views_per_video_36, t0.min_follower_count AS min_follower_count_37, t0.max_follower_count AS max_follower_count_38, t0.min_video_count AS min_video_count_39, t0.max_video_count AS max_video_count_40, t0.min_like_count AS min_like_count_41, t0.max_like_count AS max_like_count_42, t0.age_from AS age_from_43, t0.age_to AS age_to_44, t0.direction AS direction_45, t0.flat_price AS flat_price_46, t0.vip_creator AS vip_creator_47, t0.is_clipping AS is_clipping_48, t0.clip_cpm AS clip_cpm_49, t0.clip_platforms AS clip_platforms_50, t0.clip_sounds AS clip_sounds_51, t0.verified_creator AS verified_creator_52, t0.unverified_creator AS unverified_creator_53, t0.creator_geolocation_enabled AS creator_geolocation_enabled_54, t0.creator_geolocation_disabled AS creator_geolocation_disabled_55, t0.skipped_creator AS skipped_creator_56, t0.non_skipped_creator AS non_skipped_creator_57, t0.max_price_per_video AS max_price_per_video_58, t0.automatically_apply AS automatically_apply_59, t0.automatically_pay AS automatically_pay_60, t0.hide_audio AS hide_audio_61, t0.discovery_slice_enabled AS discovery_slice_enabled_62, t0.discovery_slice_percent AS discovery_slice_percent_63, t0.surge_percent AS surge_percent_64, t0.surge_ends_at AS surge_ends_at_65, t0.creator_approval_mode AS creator_approval_mode_66, t0.creator_approval_window_ends_at AS creator_approval_window_ends_at_67, t0.stat_pending AS stat_pending_68, t0.stat_creators AS stat_creators_69, t0.stat_videos AS stat_videos_70, t0.stat_views AS stat_views_71, t0.stat_likes AS stat_likes_72, t0.stat_comments AS stat_comments_73, t0.stat_shares AS stat_shares_74, t0.stat_followers AS stat_followers_75, t0.deadline_at AS deadline_at_76, t0.created_at AS created_at_77, t0.updated_at AS updated_at_78, t0.payed_at AS payed_at_79, t0.completed_at AS completed_at_80, t0.retention_checked_at AS retention_checked_at_81, t0.activated_at AS activated_at_82, t0.survey_targeting AS survey_targeting_83, t0.content_languages AS content_languages_84, t0.creator_communities AS creator_communities_85, t0.niche_semantic_matches AS niche_semantic_matches_86, t0.niche_semantic_buckets AS niche_semantic_buckets_87, t0.niches AS niches_88, t0.purchase_order AS purchase_order_89, t0.purchase_order_status AS purchase_order_status_90, t0.notification_settings AS notification_settings_91, t0.accesses AS accesses_92, t0.goal AS goal_93, t0.min_engagment_rate AS min_engagment_rate_94, t0.max_engagment_rate AS max_engagment_rate_95, t0.is_show_draft AS is_show_draft_96, t0.is_contest AS is_contest_97, t0.autocomplete_schema AS autocomplete_schema_98, t0.inbox_paid_percent AS inbox_paid_percent_99, t0.analytics_targeting AS analytics_targeting_100, t0.other_sponsor_personal_bonus AS other_sponsor_personal_bonus_101, t0.money_returned AS money_returned_102, t0.desired_creator_link1 AS desired_creator_link1_103, t0.desired_creator_link2 AS desired_creator_link2_104, t0.desired_creator_link3 AS desired_creator_link3_105, t0.promise_creators_min AS promise_creators_min_106, t0.promise_creators_max AS promise_creators_max_107, t0.promise_views_min AS promise_views_min_108, t0.promise_views_max AS promise_views_max_109, t0.promise_budget AS promise_budget_110, t0.promise_captured_at AS promise_captured_at_111, t0.promise_source AS promise_source_112, t0.parent_campaign_id AS parent_campaign_id_113, t0.speed_id AS speed_id_114, t0.sponsor_id AS sponsor_id_115, t0.song_id AS song_id_116, t0.img AS img_117, t0.created_by_manager_id AS created_by_manager_id_118 FROM campaign t0 WHERE t0.id = ? Parameters: [`17308`] View formatted query View runnable query Explain query 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.boost_spent AS boost_spent_21, t0.boost_schedule_start AS boost_schedule_start_22, t0.boost_schedule_end AS boost_schedule_end_23, t0.boost_schedule_deadline AS boost_schedule_deadline_24, t0.boost_schedule_base AS boost_schedule_base_25, t0.boost_schedule_pot AS boost_schedule_pot_26, t0.starter_offer AS starter_offer_27, t0.bonus AS bonus_28, t0.paid AS paid_29, t0.reserved AS reserved_30, t0.upsell_amount AS upsell_amount_31, t0.upsell_reserved AS upsell_reserved_32, t0.upsell_paid AS upsell_paid_33, t0.deadline_extension_count AS deadline_extension_count_34, t0.min_views_per_video AS min_views_per_video_35, t0.max_views_per_video AS max_views_per_video_36, t0.min_follower_count AS min_follower_count_37, t0.max_follower_count AS max_follower_count_38, t0.min_video_count AS min_video_count_39, t0.max_video_count AS max_video_count_40, t0.min_like_count AS min_like_count_41, t0.max_like_count AS max_like_count_42, t0.age_from AS age_from_43, t0.age_to AS age_to_44, t0.direction AS direction_45, t0.flat_price AS flat_price_46, t0.vip_creator AS vip_creator_47, t0.is_clipping AS is_clipping_48, t0.clip_cpm AS clip_cpm_49, t0.clip_platforms AS clip_platforms_50, t0.clip_sounds AS clip_sounds_51, t0.verified_creator AS verified_creator_52, t0.unverified_creator AS unverified_creator_53, t0.creator_geolocation_enabled AS creator_geolocation_enabled_54, t0.creator_geolocation_disabled AS creator_geolocation_disabled_55, t0.skipped_creator AS skipped_creator_56, t0.non_skipped_creator AS non_skipped_creator_57, t0.max_price_per_video AS max_price_per_video_58, t0.automatically_apply AS automatically_apply_59, t0.automatically_pay AS automatically_pay_60, t0.hide_audio AS hide_audio_61, t0.discovery_slice_enabled AS discovery_slice_enabled_62, t0.discovery_slice_percent AS discovery_slice_percent_63, t0.surge_percent AS surge_percent_64, t0.surge_ends_at AS surge_ends_at_65, t0.creator_approval_mode AS creator_approval_mode_66, t0.creator_approval_window_ends_at AS creator_approval_window_ends_at_67, t0.stat_pending AS stat_pending_68, t0.stat_creators AS stat_creators_69, t0.stat_videos AS stat_videos_70, t0.stat_views AS stat_views_71, t0.stat_likes AS stat_likes_72, t0.stat_comments AS stat_comments_73, t0.stat_shares AS stat_shares_74, t0.stat_followers AS stat_followers_75, t0.deadline_at AS deadline_at_76, t0.created_at AS created_at_77, t0.updated_at AS updated_at_78, t0.payed_at AS payed_at_79, t0.completed_at AS completed_at_80, t0.retention_checked_at AS retention_checked_at_81, t0.activated_at AS activated_at_82, t0.survey_targeting AS survey_targeting_83, t0.content_languages AS content_languages_84, t0.creator_communities AS creator_communities_85, t0.niche_semantic_matches AS niche_semantic_matches_86, t0.niche_semantic_buckets AS niche_semantic_buckets_87, t0.niches AS niches_88, t0.purchase_order AS purchase_order_89, t0.purchase_order_status AS purchase_order_status_90, t0.notification_settings AS notification_settings_91, t0.accesses AS accesses_92, t0.goal AS goal_93, t0.min_engagment_rate AS min_engagment_rate_94, t0.max_engagment_rate AS max_engagment_rate_95, t0.is_show_draft AS is_show_draft_96, t0.is_contest AS is_contest_97, t0.autocomplete_schema AS autocomplete_schema_98, t0.inbox_paid_percent AS inbox_paid_percent_99, t0.analytics_targeting AS analytics_targeting_100, t0.other_sponsor_personal_bonus AS other_sponsor_personal_bonus_101, t0.money_returned AS money_returned_102, t0.desired_creator_link1 AS desired_creator_link1_103, t0.desired_creator_link2 AS desired_creator_link2_104, t0.desired_creator_link3 AS desired_creator_link3_105, t0.promise_creators_min AS promise_creators_min_106, t0.promise_creators_max AS promise_creators_max_107, t0.promise_views_min AS promise_views_min_108, t0.promise_views_max AS promise_views_max_109, t0.promise_budget AS promise_budget_110, t0.promise_captured_at AS promise_captured_at_111, t0.promise_source AS promise_source_112, t0.parent_campaign_id AS parent_campaign_id_113, t0.speed_id AS speed_id_114, t0.sponsor_id AS sponsor_id_115, t0.song_id AS song_id_116, t0.img AS img_117, t0.created_by_manager_id AS created_by_manager_id_118 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.boost_spent AS boost_spent_21, t0.boost_schedule_start AS boost_schedule_start_22, t0.boost_schedule_end AS boost_schedule_end_23, t0.boost_schedule_deadline AS boost_schedule_deadline_24, t0.boost_schedule_base AS boost_schedule_base_25, t0.boost_schedule_pot AS boost_schedule_pot_26, t0.starter_offer AS starter_offer_27, t0.bonus AS bonus_28, t0.paid AS paid_29, t0.reserved AS reserved_30, t0.upsell_amount AS upsell_amount_31, t0.upsell_reserved AS upsell_reserved_32, t0.upsell_paid AS upsell_paid_33, t0.deadline_extension_count AS deadline_extension_count_34, t0.min_views_per_video AS min_views_per_video_35, t0.max_views_per_video AS max_views_per_video_36, t0.min_follower_count AS min_follower_count_37, t0.max_follower_count AS max_follower_count_38, t0.min_video_count AS min_video_count_39, t0.max_video_count AS max_video_count_40, t0.min_like_count AS min_like_count_41, t0.max_like_count AS max_like_count_42, t0.age_from AS age_from_43, t0.age_to AS age_to_44, t0.direction AS direction_45, t0.flat_price AS flat_price_46, t0.vip_creator AS vip_creator_47, t0.is_clipping AS is_clipping_48, t0.clip_cpm AS clip_cpm_49, t0.clip_platforms AS clip_platforms_50, t0.clip_sounds AS clip_sounds_51, t0.verified_creator AS verified_creator_52, t0.unverified_creator AS unverified_creator_53, t0.creator_geolocation_enabled AS creator_geolocation_enabled_54, t0.creator_geolocation_disabled AS creator_geolocation_disabled_55, t0.skipped_creator AS skipped_creator_56, t0.non_skipped_creator AS non_skipped_creator_57, t0.max_price_per_video AS max_price_per_video_58, t0.automatically_apply AS automatically_apply_59, t0.automatically_pay AS automatically_pay_60, t0.hide_audio AS hide_audio_61, t0.discovery_slice_enabled AS discovery_slice_enabled_62, t0.discovery_slice_percent AS discovery_slice_percent_63, t0.surge_percent AS surge_percent_64, t0.surge_ends_at AS surge_ends_at_65, t0.creator_approval_mode AS creator_approval_mode_66, t0.creator_approval_window_ends_at AS creator_approval_window_ends_at_67, t0.stat_pending AS stat_pending_68, t0.stat_creators AS stat_creators_69, t0.stat_videos AS stat_videos_70, t0.stat_views AS stat_views_71, t0.stat_likes AS stat_likes_72, t0.stat_comments AS stat_comments_73, t0.stat_shares AS stat_shares_74, t0.stat_followers AS stat_followers_75, t0.deadline_at AS deadline_at_76, t0.created_at AS created_at_77, t0.updated_at AS updated_at_78, t0.payed_at AS payed_at_79, t0.completed_at AS completed_at_80, t0.retention_checked_at AS retention_checked_at_81, t0.activated_at AS activated_at_82, t0.survey_targeting AS survey_targeting_83, t0.content_languages AS content_languages_84, t0.creator_communities AS creator_communities_85, t0.niche_semantic_matches AS niche_semantic_matches_86, t0.niche_semantic_buckets AS niche_semantic_buckets_87, t0.niches AS niches_88, t0.purchase_order AS purchase_order_89, t0.purchase_order_status AS purchase_order_status_90, t0.notification_settings AS notification_settings_91, t0.accesses AS accesses_92, t0.goal AS goal_93, t0.min_engagment_rate AS min_engagment_rate_94, t0.max_engagment_rate AS max_engagment_rate_95, t0.is_show_draft AS is_show_draft_96, t0.is_contest AS is_contest_97, t0.autocomplete_schema AS autocomplete_schema_98, t0.inbox_paid_percent AS inbox_paid_percent_99, t0.analytics_targeting AS analytics_targeting_100, t0.other_sponsor_personal_bonus AS other_sponsor_personal_bonus_101, t0.money_returned AS money_returned_102, t0.desired_creator_link1 AS desired_creator_link1_103, t0.desired_creator_link2 AS desired_creator_link2_104, t0.desired_creator_link3 AS desired_creator_link3_105, t0.promise_creators_min AS promise_creators_min_106, t0.promise_creators_max AS promise_creators_max_107, t0.promise_views_min AS promise_views_min_108, t0.promise_views_max AS promise_views_max_109, t0.promise_budget AS promise_budget_110, t0.promise_captured_at AS promise_captured_at_111, t0.promise_source AS promise_source_112, t0.parent_campaign_id AS parent_campaign_id_113, t0.speed_id AS speed_id_114, t0.sponsor_id AS sponsor_id_115, t0.song_id AS song_id_116, t0.img AS img_117, t0.created_by_manager_id AS created_by_manager_id_118 FROM campaign t0 WHERE t0.id = 17308;
13	0.73 ms	SELECT t0.lyrics AS lyrics_1, t0.transcribed_at AS transcribed_at_2, t0.audio_profile AS audio_profile_3, t0.audio_profiled_at AS audio_profiled_at_4, t0.id AS id_5, t0.name AS name_6, t0.artist AS artist_7, t0.url AS url_8, t0.external_id AS external_id_9, t0.file AS file_10, t0.image AS image_11, t0.created_at AS created_at_12 FROM song t0 WHERE t0.id = ? Parameters: [`9729`] View formatted query View runnable query Explain query SELECT t0.lyrics AS lyrics_1, t0.transcribed_at AS transcribed_at_2, t0.audio_profile AS audio_profile_3, t0.audio_profiled_at AS audio_profiled_at_4, t0.id AS id_5, t0.name AS name_6, t0.artist AS artist_7, t0.url AS url_8, t0.external_id AS external_id_9, t0.file AS file_10, t0.image AS image_11, t0.created_at AS created_at_12 FROM song t0 WHERE t0.id = ? SELECT t0.lyrics AS lyrics_1, t0.transcribed_at AS transcribed_at_2, t0.audio_profile AS audio_profile_3, t0.audio_profiled_at AS audio_profiled_at_4, t0.id AS id_5, t0.name AS name_6, t0.artist AS artist_7, t0.url AS url_8, t0.external_id AS external_id_9, t0.file AS file_10, t0.image AS image_11, t0.created_at AS created_at_12 FROM song t0 WHERE t0.id = 9729;
14	0.82 ms	SELECT t0.id AS id_1, t0.curator_user_id AS curator_user_id_2, t0.curated_at AS curated_at_3, t0.video_review_at AS video_review_at_4, t0.clip_seq AS clip_seq_5, t0.resubmission_count AS resubmission_count_6, t0.boost_status AS boost_status_7, t0.boost_requested_by_admin AS boost_requested_by_admin_8, t0.draft_requested AS draft_requested_9, t0.status AS status_10, t0.amount AS amount_11, t0.cpm AS cpm_12, t0.paid AS paid_13, t0.personal_bonus AS personal_bonus_14, t0.followers AS followers_15, t0.averageViews AS averageViews_16, t0.vip_multiplier AS vip_multiplier_17, t0.reserved_amount AS reserved_amount_18, t0.verified_audience_pricing_v3 AS verified_audience_pricing_v3_19, t0.analytics_freshness_decay AS analytics_freshness_decay_20, t0.reason AS reason_21, t0.dispute_reason AS dispute_reason_22, t0.video_deadline_at AS video_deadline_at_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.payed_at AS payed_at_26, t0.video_removed_after_earning_at AS video_removed_after_earning_at_27, t0.video_removed_views AS video_removed_views_28, t0.video_removed_notified_at AS video_removed_notified_at_29, t0.upsell_status AS upsell_status_30, t0.upsell_asking_price AS upsell_asking_price_31, t0.upsell_sale_percent AS upsell_sale_percent_32, t0.upsell_list_price AS upsell_list_price_33, t0.upsell_approved_price AS upsell_approved_price_34, t0.upsell_platform_fee AS upsell_platform_fee_35, t0.shadow_ban_price AS shadow_ban_price_36, t0.shadow_ban_suggested_price AS shadow_ban_suggested_price_37, t0.negotiated_price_gross AS negotiated_price_gross_38, t0.negotiated_offer_id AS negotiated_offer_id_39, t0.upsell_charge_id AS upsell_charge_id_40, t0.upsell_refund_id AS upsell_refund_id_41, t0.upsell_approved_at AS upsell_approved_at_42, t0.upsell_refunded_at AS upsell_refunded_at_43, t0.upsell_attempt_token AS upsell_attempt_token_44, t0.personal_rate_net AS personal_rate_net_45, t0.personal_rate_cost_per_view AS personal_rate_cost_per_view_46, t0.personal_rate_median_views AS personal_rate_median_views_47, t0.personal_rate_commission_percent AS personal_rate_commission_percent_48, t0.personal_rate_curve AS personal_rate_curve_49, t0.personal_rate_algo_cost_per_view AS personal_rate_algo_cost_per_view_50, t0.rating_multiplier AS rating_multiplier_51, t0.boost_engagement_multiplier AS boost_engagement_multiplier_52, t0.surge_percent_applied AS surge_percent_applied_53, t0.creator_id AS creator_id_54, t0.campaign_id AS campaign_id_55, t0.video_id AS video_id_56, t0.declined_video_id AS declined_video_id_57, t0.complaint_id AS complaint_id_58 FROM activity t0 WHERE t0.id = ? Parameters: [`12975661`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.curator_user_id AS curator_user_id_2, t0.curated_at AS curated_at_3, t0.video_review_at AS video_review_at_4, t0.clip_seq AS clip_seq_5, t0.resubmission_count AS resubmission_count_6, t0.boost_status AS boost_status_7, t0.boost_requested_by_admin AS boost_requested_by_admin_8, t0.draft_requested AS draft_requested_9, t0.status AS status_10, t0.amount AS amount_11, t0.cpm AS cpm_12, t0.paid AS paid_13, t0.personal_bonus AS personal_bonus_14, t0.followers AS followers_15, t0.averageViews AS averageViews_16, t0.vip_multiplier AS vip_multiplier_17, t0.reserved_amount AS reserved_amount_18, t0.verified_audience_pricing_v3 AS verified_audience_pricing_v3_19, t0.analytics_freshness_decay AS analytics_freshness_decay_20, t0.reason AS reason_21, t0.dispute_reason AS dispute_reason_22, t0.video_deadline_at AS video_deadline_at_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.payed_at AS payed_at_26, t0.video_removed_after_earning_at AS video_removed_after_earning_at_27, t0.video_removed_views AS video_removed_views_28, t0.video_removed_notified_at AS video_removed_notified_at_29, t0.upsell_status AS upsell_status_30, t0.upsell_asking_price AS upsell_asking_price_31, t0.upsell_sale_percent AS upsell_sale_percent_32, t0.upsell_list_price AS upsell_list_price_33, t0.upsell_approved_price AS upsell_approved_price_34, t0.upsell_platform_fee AS upsell_platform_fee_35, t0.shadow_ban_price AS shadow_ban_price_36, t0.shadow_ban_suggested_price AS shadow_ban_suggested_price_37, t0.negotiated_price_gross AS negotiated_price_gross_38, t0.negotiated_offer_id AS negotiated_offer_id_39, t0.upsell_charge_id AS upsell_charge_id_40, t0.upsell_refund_id AS upsell_refund_id_41, t0.upsell_approved_at AS upsell_approved_at_42, t0.upsell_refunded_at AS upsell_refunded_at_43, t0.upsell_attempt_token AS upsell_attempt_token_44, t0.personal_rate_net AS personal_rate_net_45, t0.personal_rate_cost_per_view AS personal_rate_cost_per_view_46, t0.personal_rate_median_views AS personal_rate_median_views_47, t0.personal_rate_commission_percent AS personal_rate_commission_percent_48, t0.personal_rate_curve AS personal_rate_curve_49, t0.personal_rate_algo_cost_per_view AS personal_rate_algo_cost_per_view_50, t0.rating_multiplier AS rating_multiplier_51, t0.boost_engagement_multiplier AS boost_engagement_multiplier_52, t0.surge_percent_applied AS surge_percent_applied_53, t0.creator_id AS creator_id_54, t0.campaign_id AS campaign_id_55, t0.video_id AS video_id_56, t0.declined_video_id AS declined_video_id_57, t0.complaint_id AS complaint_id_58 FROM activity t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.curator_user_id AS curator_user_id_2, t0.curated_at AS curated_at_3, t0.video_review_at AS video_review_at_4, t0.clip_seq AS clip_seq_5, t0.resubmission_count AS resubmission_count_6, t0.boost_status AS boost_status_7, t0.boost_requested_by_admin AS boost_requested_by_admin_8, t0.draft_requested AS draft_requested_9, t0.status AS status_10, t0.amount AS amount_11, t0.cpm AS cpm_12, t0.paid AS paid_13, t0.personal_bonus AS personal_bonus_14, t0.followers AS followers_15, t0.averageViews AS averageViews_16, t0.vip_multiplier AS vip_multiplier_17, t0.reserved_amount AS reserved_amount_18, t0.verified_audience_pricing_v3 AS verified_audience_pricing_v3_19, t0.analytics_freshness_decay AS analytics_freshness_decay_20, t0.reason AS reason_21, t0.dispute_reason AS dispute_reason_22, t0.video_deadline_at AS video_deadline_at_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.payed_at AS payed_at_26, t0.video_removed_after_earning_at AS video_removed_after_earning_at_27, t0.video_removed_views AS video_removed_views_28, t0.video_removed_notified_at AS video_removed_notified_at_29, t0.upsell_status AS upsell_status_30, t0.upsell_asking_price AS upsell_asking_price_31, t0.upsell_sale_percent AS upsell_sale_percent_32, t0.upsell_list_price AS upsell_list_price_33, t0.upsell_approved_price AS upsell_approved_price_34, t0.upsell_platform_fee AS upsell_platform_fee_35, t0.shadow_ban_price AS shadow_ban_price_36, t0.shadow_ban_suggested_price AS shadow_ban_suggested_price_37, t0.negotiated_price_gross AS negotiated_price_gross_38, t0.negotiated_offer_id AS negotiated_offer_id_39, t0.upsell_charge_id AS upsell_charge_id_40, t0.upsell_refund_id AS upsell_refund_id_41, t0.upsell_approved_at AS upsell_approved_at_42, t0.upsell_refunded_at AS upsell_refunded_at_43, t0.upsell_attempt_token AS upsell_attempt_token_44, t0.personal_rate_net AS personal_rate_net_45, t0.personal_rate_cost_per_view AS personal_rate_cost_per_view_46, t0.personal_rate_median_views AS personal_rate_median_views_47, t0.personal_rate_commission_percent AS personal_rate_commission_percent_48, t0.personal_rate_curve AS personal_rate_curve_49, t0.personal_rate_algo_cost_per_view AS personal_rate_algo_cost_per_view_50, t0.rating_multiplier AS rating_multiplier_51, t0.boost_engagement_multiplier AS boost_engagement_multiplier_52, t0.surge_percent_applied AS surge_percent_applied_53, t0.creator_id AS creator_id_54, t0.campaign_id AS campaign_id_55, t0.video_id AS video_id_56, t0.declined_video_id AS declined_video_id_57, t0.complaint_id AS complaint_id_58 FROM activity t0 WHERE t0.id = 12975661;
15	0.89 ms	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.password AS password_25, t0.company_name AS company_name_26, t0.company_website AS company_website_27, t0.job_title AS job_title_28, t0.country AS country_29, t0.about_us AS about_us_30, t0.promote AS promote_31, t0.credit AS credit_32, t0.with_payment_process AS with_payment_process_33, t0.has_creator_account AS has_creator_account_34, t0.notify_email AS notify_email_35, t0.notify_sms AS notify_sms_36, t0.credit_limit AS credit_limit_37, t0.used_credit AS used_credit_38, t0.store_credit AS store_credit_39, t0.permissions AS permissions_40, t0.total_creators AS total_creators_41, t0.total_videos AS total_videos_42, t0.total_views AS total_views_43, t0.total_price AS total_price_44, t0.referral_source AS referral_source_45, t0.referral_source_other AS referral_source_other_46, t0.paypal_id AS paypal_id_47, t0.starter_offer_expires_at AS starter_offer_expires_at_48, t0.referral_prompt_dismissed_at AS referral_prompt_dismissed_at_49, t0.referral_prompt_dismissals AS referral_prompt_dismissals_50, t1.role FROM sponsor t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ? Parameters: [`2678441`] View formatted query View runnable query Explain query 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.password AS password_25, t0.company_name AS company_name_26, t0.company_website AS company_website_27, t0.job_title AS job_title_28, t0.country AS country_29, t0.about_us AS about_us_30, t0.promote AS promote_31, t0.credit AS credit_32, t0.with_payment_process AS with_payment_process_33, t0.has_creator_account AS has_creator_account_34, t0.notify_email AS notify_email_35, t0.notify_sms AS notify_sms_36, t0.credit_limit AS credit_limit_37, t0.used_credit AS used_credit_38, t0.store_credit AS store_credit_39, t0.permissions AS permissions_40, t0.total_creators AS total_creators_41, t0.total_videos AS total_videos_42, t0.total_views AS total_views_43, t0.total_price AS total_price_44, t0.referral_source AS referral_source_45, t0.referral_source_other AS referral_source_other_46, t0.paypal_id AS paypal_id_47, t0.starter_offer_expires_at AS starter_offer_expires_at_48, t0.referral_prompt_dismissed_at AS referral_prompt_dismissed_at_49, t0.referral_prompt_dismissals AS referral_prompt_dismissals_50, 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.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.password AS password_25, t0.company_name AS company_name_26, t0.company_website AS company_website_27, t0.job_title AS job_title_28, t0.country AS country_29, t0.about_us AS about_us_30, t0.promote AS promote_31, t0.credit AS credit_32, t0.with_payment_process AS with_payment_process_33, t0.has_creator_account AS has_creator_account_34, t0.notify_email AS notify_email_35, t0.notify_sms AS notify_sms_36, t0.credit_limit AS credit_limit_37, t0.used_credit AS used_credit_38, t0.store_credit AS store_credit_39, t0.permissions AS permissions_40, t0.total_creators AS total_creators_41, t0.total_videos AS total_videos_42, t0.total_views AS total_views_43, t0.total_price AS total_price_44, t0.referral_source AS referral_source_45, t0.referral_source_other AS referral_source_other_46, t0.paypal_id AS paypal_id_47, t0.starter_offer_expires_at AS starter_offer_expires_at_48, t0.referral_prompt_dismissed_at AS referral_prompt_dismissed_at_49, t0.referral_prompt_dismissals AS referral_prompt_dismissals_50, t1.role FROM sponsor t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = 2678441;
16	0.56 ms	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 = ? Parameters: [`2678441`] View formatted query View runnable query Explain query 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 = 2678441;
17	0.48 ms	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 = ? Parameters: [`2678441`] View formatted query View runnable query Explain query 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 = 2678441;
18	0.64 ms	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.reward_block_reason AS reward_block_reason_7, t0.referral_tail_commission_percent AS referral_tail_commission_percent_8, t0.referral_tail_duration_days AS referral_tail_duration_days_9, t0.balance AS balance_10, t0.id AS id_11, t0.referred_by_id AS referred_by_id_12 FROM referral t0 WHERE t0.id = ? Parameters: [`2678441`] View formatted query View runnable query Explain query 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.reward_block_reason AS reward_block_reason_7, t0.referral_tail_commission_percent AS referral_tail_commission_percent_8, t0.referral_tail_duration_days AS referral_tail_duration_days_9, t0.balance AS balance_10, t0.id AS id_11, t0.referred_by_id AS referred_by_id_12 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.reward_block_reason AS reward_block_reason_7, t0.referral_tail_commission_percent AS referral_tail_commission_percent_8, t0.referral_tail_duration_days AS referral_tail_duration_days_9, t0.balance AS balance_10, t0.id AS id_11, t0.referred_by_id AS referred_by_id_12 FROM referral t0 WHERE t0.id = 2678441;
19	0.49 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.amount AS amount_3, t0.hours AS hours_4, t0.percent AS percent_5 FROM speed t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.amount AS amount_3, t0.hours AS hours_4, t0.percent AS percent_5 FROM speed t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.amount AS amount_3, t0.hours AS hours_4, t0.percent AS percent_5 FROM speed t0 WHERE t0.id = 1;
20	1.00 ms	SELECT m0_.id AS id_0, m0_.sender_type AS sender_type_1, m0_.sender_user_id AS sender_user_id_2, m0_.kind AS kind_3, m0_.body AS body_4, m0_.moderation_verdict AS moderation_verdict_5, m0_.created_at AS created_at_6, m0_.review_status AS review_status_7, m0_.reviewed_at AS reviewed_at_8, m0_.reviewed_by_user_id AS reviewed_by_user_id_9, m0_.review_note AS review_note_10, o1_.id AS id_11, o1_.proposed_by AS proposed_by_12, o1_.proposed_by_user_id AS proposed_by_user_id_13, o1_.amount_gross AS amount_gross_14, o1_.currency AS currency_15, o1_.note AS note_16, o1_.status AS status_17, o1_.expires_at AS expires_at_18, o1_.decided_at AS decided_at_19, o1_.decided_by_user_id AS decided_by_user_id_20, o1_.supersedes_offer_id AS supersedes_offer_id_21, o1_.superseded_by_offer_id AS superseded_by_offer_id_22, o1_.created_at AS created_at_23, m0_.conversation_id AS conversation_id_24, m0_.offer_id AS offer_id_25, o1_.conversation_id AS conversation_id_26, o1_.activity_id AS activity_id_27 FROM message m0_ LEFT JOIN offer o1_ ON m0_.offer_id = o1_.id WHERE m0_.conversation_id = ? AND m0_.id > ? ORDER BY m0_.id ASC LIMIT 50 Parameters: [`"1" 7`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.sender_type AS sender_type_1, m0_.sender_user_id AS sender_user_id_2, m0_.kind AS kind_3, m0_.body AS body_4, m0_.moderation_verdict AS moderation_verdict_5, m0_.created_at AS created_at_6, m0_.review_status AS review_status_7, m0_.reviewed_at AS reviewed_at_8, m0_.reviewed_by_user_id AS reviewed_by_user_id_9, m0_.review_note AS review_note_10, o1_.id AS id_11, o1_.proposed_by AS proposed_by_12, o1_.proposed_by_user_id AS proposed_by_user_id_13, o1_.amount_gross AS amount_gross_14, o1_.currency AS currency_15, o1_.note AS note_16, o1_.status AS status_17, o1_.expires_at AS expires_at_18, o1_.decided_at AS decided_at_19, o1_.decided_by_user_id AS decided_by_user_id_20, o1_.supersedes_offer_id AS supersedes_offer_id_21, o1_.superseded_by_offer_id AS superseded_by_offer_id_22, o1_.created_at AS created_at_23, m0_.conversation_id AS conversation_id_24, m0_.offer_id AS offer_id_25, o1_.conversation_id AS conversation_id_26, o1_.activity_id AS activity_id_27 FROM message m0_ LEFT JOIN offer o1_ ON m0_.offer_id = o1_.id WHERE m0_.conversation_id = ? AND m0_.id > ? ORDER BY m0_.id ASC LIMIT 50 SELECT m0_.id AS id_0, m0_.sender_type AS sender_type_1, m0_.sender_user_id AS sender_user_id_2, m0_.kind AS kind_3, m0_.body AS body_4, m0_.moderation_verdict AS moderation_verdict_5, m0_.created_at AS created_at_6, m0_.review_status AS review_status_7, m0_.reviewed_at AS reviewed_at_8, m0_.reviewed_by_user_id AS reviewed_by_user_id_9, m0_.review_note AS review_note_10, o1_.id AS id_11, o1_.proposed_by AS proposed_by_12, o1_.proposed_by_user_id AS proposed_by_user_id_13, o1_.amount_gross AS amount_gross_14, o1_.currency AS currency_15, o1_.note AS note_16, o1_.status AS status_17, o1_.expires_at AS expires_at_18, o1_.decided_at AS decided_at_19, o1_.decided_by_user_id AS decided_by_user_id_20, o1_.supersedes_offer_id AS supersedes_offer_id_21, o1_.superseded_by_offer_id AS superseded_by_offer_id_22, o1_.created_at AS created_at_23, m0_.conversation_id AS conversation_id_24, m0_.offer_id AS offer_id_25, o1_.conversation_id AS conversation_id_26, o1_.activity_id AS activity_id_27 FROM message m0_ LEFT JOIN offer o1_ ON m0_.offer_id = o1_.id WHERE m0_.conversation_id = '1' AND m0_.id > 7 ORDER BY m0_.id ASC LIMIT 50;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	3
App\Entity\Referral	3
App\Entity\UserLocationPermission	2
App\Entity\Country	2
App\Entity\PaymentBalance	2
App\Entity\Conversation	1
App\Entity\Activity	1
App\Entity\Campaign	1
App\Entity\TikTokAuth	1
App\Entity\Speed	1
App\Entity\Song	1

Entities Mapping

Class	Mapping errors
App\Entity\User	The field App\Entity\User#locationPermissionTelemetry is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserLocationPermission#user does not contain the required 'inversedBy="locationPermissionTelemetry"' attribute. The field App\Entity\User#paymentBalance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PaymentBalance#user does not contain the required 'inversedBy="paymentBalance"' attribute. The field App\Entity\User#referral is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Referral#user does not contain the required 'inversedBy="referral"' attribute. The field App\Entity\User#referrals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Referral#referredBy does not contain the required 'inversedBy="referrals"' attribute.
App\Entity\Creator	The field App\Entity\Creator#locationPermissionTelemetry is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserLocationPermission#user does not contain the required 'inversedBy="locationPermissionTelemetry"' attribute. The field App\Entity\Creator#paymentBalance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PaymentBalance#user does not contain the required 'inversedBy="paymentBalance"' attribute. The field App\Entity\Creator#referral is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Referral#user does not contain the required 'inversedBy="referral"' attribute. The field App\Entity\Creator#referrals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Referral#referredBy does not contain the required 'inversedBy="referrals"' attribute. The field App\Entity\Creator#surveyAnswers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Survey\UserAnswer#creator does not contain the required 'inversedBy="surveyAnswers"' attribute.
App\Entity\TikTokAuth	No errors.
App\Entity\InstagramAuth	No errors.
App\Entity\YoutubeAuth	No errors.
App\Entity\Geolocation	No errors.
App\Entity\Country	No errors.
App\Entity\UserLocationPermission	No errors.
App\Entity\PaymentBalance	No errors.
App\Entity\Referral	The association App\Entity\Referral#referrals refers to the owning side field App\Entity\User#referredBy which does not exist.
App\Entity\Roster	No errors.
App\Entity\Activity	No errors.
App\Entity\Badge	No errors.
App\Entity\Device	No errors.
App\Entity\Survey\UserAnswer	No errors.
App\Entity\Video	No errors.
App\Entity\AnalyticsCreatorsData	No errors.
App\Entity\Conversation	No errors.
App\Entity\Campaign	No errors.
App\Entity\Sponsor	The field App\Entity\Sponsor#locationPermissionTelemetry is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserLocationPermission#user does not contain the required 'inversedBy="locationPermissionTelemetry"' attribute. The field App\Entity\Sponsor#paymentBalance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PaymentBalance#user does not contain the required 'inversedBy="paymentBalance"' attribute. The field App\Entity\Sponsor#referral is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Referral#user does not contain the required 'inversedBy="referral"' attribute. The field App\Entity\Sponsor#referrals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Referral#referredBy does not contain the required 'inversedBy="referrals"' attribute. The field App\Entity\Sponsor#campaigns is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Campaign#sponsor does not contain the required 'inversedBy="campaigns"' attribute. The field App\Entity\Sponsor#managers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Manager#sponsor does not contain the required 'inversedBy="managers"' attribute.
App\Entity\Speed	No errors.
App\Entity\Song	No errors.
App\Entity\File	No errors.
App\Entity\Manager	The field App\Entity\Manager#locationPermissionTelemetry is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserLocationPermission#user does not contain the required 'inversedBy="locationPermissionTelemetry"' attribute. The field App\Entity\Manager#paymentBalance is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PaymentBalance#user does not contain the required 'inversedBy="paymentBalance"' attribute. The field App\Entity\Manager#referral is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Referral#user does not contain the required 'inversedBy="referral"' attribute. The field App\Entity\Manager#referrals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Referral#referredBy does not contain the required 'inversedBy="referrals"' attribute.
App\Entity\Label	No errors.
App\Entity\Complaint	No errors.
App\Entity\VideoPending	No errors.
App\Entity\DraftVideo	No errors.
App\Entity\Message	No errors.
App\Entity\Offer	No errors.

Symfony Profiler

GET https://api.v2.staging.sound.me/api/v1/creator/messaging/conversations/1/messages?limit=50&since=7

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping