POST https://api.v2.staging.sound.me/api/v1/sponsor/refresh

Query Metrics

4 Database Queries
4 Different statements
2.92 ms Query time
4 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 0.98 ms
SELECT t1.id AS id_2, t1.status AS status_3, t1.email AS email_4, t1.pending_email AS pending_email_5, t1.phone_number AS phone_number_6, t1.first_name AS first_name_7, t1.last_name AS last_name_8, t1.language AS language_9, t1.blocked_until AS blocked_until_10, t1.block_scope AS block_scope_11, t1.created_at AS created_at_12, t1.updated_at AS updated_at_13, t1.last_login_at AS last_login_at_14, t1.last_activity_at AS last_activity_at_15, t1.previous_activity_at AS previous_activity_at_16, t1.returned_at AS returned_at_17, t1.last_activity AS last_activity_18, t1.deleted_at AS deleted_at_19, t1.credentials_changed_at AS credentials_changed_at_20, t0.password AS password_21, t0.company_name AS company_name_22, t0.company_website AS company_website_23, t0.job_title AS job_title_24, t0.country AS country_25, t0.about_us AS about_us_26, t0.promote AS promote_27, t0.credit AS credit_28, t0.with_payment_process AS with_payment_process_29, t0.has_creator_account AS has_creator_account_30, t0.notify_email AS notify_email_31, t0.notify_sms AS notify_sms_32, t0.credit_limit AS credit_limit_33, t0.used_credit AS used_credit_34, t0.store_credit AS store_credit_35, t0.permissions AS permissions_36, t0.total_creators AS total_creators_37, t0.total_videos AS total_videos_38, t0.total_views AS total_views_39, t0.total_price AS total_price_40, t0.referral_source AS referral_source_41, t0.referral_source_other AS referral_source_other_42, t0.paypal_id AS paypal_id_43, t1.role FROM sponsor t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  2667810
]
2 0.66 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:
[
  2667810
]
3 0.64 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:
[
  2667810
]
4 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.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:
[
  2667810
]

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 1
App\Entity\PaymentBalance 1
App\Entity\Referral 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\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\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\Campaign 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.