https://apis.staging.sound.me/api/v1/creators/profiles/2673592

Query Metrics

9 Database Queries
8 Different statements
8.52 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.13 ms
(48.52%)
2
SELECT u0_.id AS id_0, u0_.status AS status_1, u0_.email AS email_2, u0_.phone_number AS phone_number_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.language AS language_6, u0_.blocked_until AS blocked_until_7, u0_.created_at AS created_at_8, u0_.updated_at AS updated_at_9, u0_.deleted_at AS deleted_at_10, c1_.platform AS platform_11, c1_.username AS username_12, c1_.gender AS gender_13, c1_.birthday AS birthday_14, c1_.minimal_amount AS minimal_amount_15, c1_.minimal_vip_amount AS minimal_vip_amount_16, c1_.followers AS followers_17, c1_.likes AS likes_18, c1_.average_views AS average_views_19, c1_.engagement_rate AS engagement_rate_20, c1_.average_views_coeff AS average_views_coeff_21, c1_.videos AS videos_22, c1_.tier AS tier_23, c1_.ethnicity AS ethnicity_24, c1_.category_gender AS category_gender_25, c1_.age_group AS age_group_26, c1_.category_parent AS category_parent_27, c1_.attractiveness_level AS attractiveness_level_28, c1_.phone_notify_campaigns AS phone_notify_campaigns_29, c1_.email_notify_campaigns AS email_notify_campaigns_30, c1_.email_notify_newsletter AS email_notify_newsletter_31, c1_.vip AS vip_32, c1_.vip_multiplier AS vip_multiplier_33, c1_.dark_theme AS dark_theme_34, c1_.is_survey_required AS is_survey_required_35, c1_.is_active AS is_active_36, c1_.locked_tik_tok_union_id AS locked_tik_tok_union_id_37, c1_.locked_at AS locked_at_38, c1_.bio AS bio_39, c1_.facebook AS facebook_40, c1_.youtube AS youtube_41, c1_.instagram AS instagram_42, c1_.twitter AS twitter_43, c1_.cover AS cover_44, c1_.profile_picture_url AS profile_picture_url_45, c1_.paypal_id AS paypal_id_46, c1_.tik_tok_id AS tik_tok_id_47, c1_.last_notifications AS last_notifications_48, c1_.updates AS updates_49, c1_.last_active_at AS last_active_at_50, c1_.scraped_at AS scraped_at_51, c1_.video_scraped_at AS video_scraped_at_52, c1_.can_change_country AS can_change_country_53, c1_.skipped_at AS skipped_at_54, c1_.verified_at AS verified_at_55, c1_.min_flat_fee AS min_flat_fee_56, c1_.is_show_less_than_flat_fee AS is_show_less_than_flat_fee_57, c1_.stripe_id AS stripe_id_58, c1_.password AS password_59, c1_.stripe_connected AS stripe_connected_60, t2_.id AS id_61, t2_.union_id AS union_id_62, t2_.access_token AS access_token_63, t2_.refresh_token AS refresh_token_64, t2_.refreshed_at AS refreshed_at_65, t2_.refresh_expires_at AS refresh_expires_at_66, t2_.needs_reconnect AS needs_reconnect_67, t2_.refresh_failed_at AS refresh_failed_at_68, t2_.access_token_expires_at AS access_token_expires_at_69, t2_.reconnect_email_sent_at AS reconnect_email_sent_at_70, i3_.id AS id_71, i3_.ig_id AS ig_id_72, i3_.access_token AS access_token_73, i3_.refreshed_at AS refreshed_at_74, i3_.expires_at AS expires_at_75, i3_.created_at AS created_at_76, y4_.id AS id_77, y4_.channel_id AS channel_id_78, y4_.access_token AS access_token_79, y4_.refresh_token AS refresh_token_80, y4_.scope AS scope_81, y4_.token_type AS token_type_82, y4_.expired_in AS expired_in_83, y4_.created_at AS created_at_84, u0_.role AS role_85, c1_.tik_tok_auth_id AS tik_tok_auth_id_86, c1_.instagram_auth_id AS instagram_auth_id_87, c1_.youtube_auth_id AS youtube_auth_id_88, c1_.geolocation_id AS geolocation_id_89, c1_.country_id AS country_id_90, c1_.initially_country_id AS initially_country_id_91, c1_.user_id AS user_id_92 FROM creator c1_ INNER JOIN user u0_ ON c1_.id = u0_.id LEFT JOIN tik_tok_auth t2_ ON c1_.tik_tok_auth_id = t2_.id LEFT JOIN instagram_auth i3_ ON c1_.instagram_auth_id = i3_.id LEFT JOIN youtube_auth y4_ ON c1_.youtube_auth_id = y4_.id WHERE c1_.user_id = ? OR ((u0_.id = ? AND c1_.user_id IS NULL))
Parameters:
[
  "2673592"
  2673592
]
1.03 ms
(12.12%)
1
SELECT t1.id AS id_2, t1.status AS status_3, t1.email AS email_4, t1.phone_number AS phone_number_5, t1.first_name AS first_name_6, t1.last_name AS last_name_7, t1.language AS language_8, t1.blocked_until AS blocked_until_9, t1.created_at AS created_at_10, t1.updated_at AS updated_at_11, t1.deleted_at AS deleted_at_12, t0.platform AS platform_13, t0.username AS username_14, t0.gender AS gender_15, t0.birthday AS birthday_16, t0.minimal_amount AS minimal_amount_17, t0.minimal_vip_amount AS minimal_vip_amount_18, t0.followers AS followers_19, t0.likes AS likes_20, t0.average_views AS average_views_21, t0.engagement_rate AS engagement_rate_22, t0.average_views_coeff AS average_views_coeff_23, t0.videos AS videos_24, t0.tier AS tier_25, t0.ethnicity AS ethnicity_26, t0.category_gender AS category_gender_27, t0.age_group AS age_group_28, t0.category_parent AS category_parent_29, t0.attractiveness_level AS attractiveness_level_30, t0.phone_notify_campaigns AS phone_notify_campaigns_31, t0.email_notify_campaigns AS email_notify_campaigns_32, t0.email_notify_newsletter AS email_notify_newsletter_33, t0.vip AS vip_34, t0.vip_multiplier AS vip_multiplier_35, t0.dark_theme AS dark_theme_36, t0.is_survey_required AS is_survey_required_37, t0.is_active AS is_active_38, t0.locked_tik_tok_union_id AS locked_tik_tok_union_id_39, t0.locked_at AS locked_at_40, t0.bio AS bio_41, t0.facebook AS facebook_42, t0.youtube AS youtube_43, t0.instagram AS instagram_44, t0.twitter AS twitter_45, t0.cover AS cover_46, t0.profile_picture_url AS profile_picture_url_47, t0.paypal_id AS paypal_id_48, t0.tik_tok_id AS tik_tok_id_49, t0.last_notifications AS last_notifications_50, t0.updates AS updates_51, t0.last_active_at AS last_active_at_52, t0.scraped_at AS scraped_at_53, t0.video_scraped_at AS video_scraped_at_54, t0.can_change_country AS can_change_country_55, t0.skipped_at AS skipped_at_56, t0.verified_at AS verified_at_57, t0.min_flat_fee AS min_flat_fee_58, t0.is_show_less_than_flat_fee AS is_show_less_than_flat_fee_59, t0.stripe_id AS stripe_id_60, t0.password AS password_61, t0.stripe_connected AS stripe_connected_62, t0.tik_tok_auth_id AS tik_tok_auth_id_63, t0.instagram_auth_id AS instagram_auth_id_64, t0.youtube_auth_id AS youtube_auth_id_65, t0.geolocation_id AS geolocation_id_66, t0.country_id AS country_id_67, t0.initially_country_id AS initially_country_id_68, t0.user_id AS user_id_69, t1.role FROM creator t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  2673592
]
0.68 ms
(7.96%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.sponsor_id AS sponsor_id_5 FROM roster t0 INNER JOIN roster_creator ON t0.id = roster_creator.roster_id WHERE roster_creator.creator_id = ?
Parameters:
[
  2673592
]
0.60 ms
(7.06%)
1
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:
[
  2673592
]
0.60 ms
(7.03%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.sms_enabled AS sms_enabled_4, t0.cpm_rate AS cpm_rate_5, t0.region_id AS region_id_6 FROM country t0 WHERE t0.id = ?
Parameters:
[
  1000
]
0.55 ms
(6.43%)
1
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:
[
  2673592
]
0.47 ms
(5.48%)
1
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:
[
  2673592
]
0.46 ms
(5.40%)
1
SELECT t0.code AS code_1, t0.is_enabled AS is_enabled_2, t0.duration_days_per_referred_user AS duration_days_per_referred_user_3, t0.referred_by_ended_at AS referred_by_ended_at_4, t0.referral_activity_commission_percent AS referral_activity_commission_percent_5, t0.referral_new_campaign_commission_percent AS referral_new_campaign_commission_percent_6, t0.balance AS balance_7, t0.id AS id_8, t0.referred_by_id AS referred_by_id_9 FROM referral t0 WHERE t0.id = ?
Parameters:
[
  2673592
]

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.

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\Region No errors.
App\Entity\CountryPhoneCode No errors.