Query Metrics
20
Database Queries
12
Different statements
16.38 ms
Query time
5
Invalid entities
18
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.79 ms (17.03%) |
2 |
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
]
|
|
2.08 ms (12.68%) |
3 |
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
]
|
|
2.04 ms (12.47%) |
3 |
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
]
|
|
1.77 ms (10.79%) |
3 |
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
]
|
|
1.38 ms (8.41%) |
2 |
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
]
|
|
1.24 ms (7.57%) |
1 |
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
]
|
|
0.99 ms (6.06%) |
1 |
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
]
|
|
0.97 ms (5.93%) |
1 |
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 ] |
|
0.94 ms (5.74%) |
1 |
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
]
|
|
0.92 ms (5.63%) |
1 |
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
]
|
|
0.71 ms (4.32%) |
1 |
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
]
|
|
0.55 ms (3.38%) |
1 |
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
]
|
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 |
|
| App\Entity\Creator |
|
| 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 |
|
| 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 |
|
| App\Entity\Speed | No errors. |
| App\Entity\Song | No errors. |
| App\Entity\File | No errors. |
| App\Entity\Manager |
|
| 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. |