Query Metrics
9
Database Queries
8
Different statements
8.52 ms
Query time
3
Invalid entities
Grouped Statements
| 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 |
|
| 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\Region | No errors. |
| App\Entity\CountryPhoneCode | No errors. |