Query Metrics
4
Database Queries
4
Different statements
2.92 ms
Query time
4
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.98 ms (33.47%) |
1 |
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
]
|
|
0.66 ms (22.71%) |
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:
[
2667810
]
|
|
0.64 ms (22.06%) |
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:
[
2667810
]
|
|
0.64 ms (21.76%) |
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:
[
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 |
|
| App\Entity\Sponsor |
|
| App\Entity\UserLocationPermission | No errors. |
| App\Entity\PaymentBalance | No errors. |
| App\Entity\Referral |
|
| App\Entity\Campaign | No errors. |
| App\Entity\Manager |
|