Query Metrics
11
Database Queries
9
Different statements
31.42 ms
Query time
1
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.39 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.username AS username_6, t0.name AS name_7, t0.address AS address_8, t0.phone_number AS phone_number_9, t0.profile_pic AS profile_pic_10, t0.oauth_provider AS oauth_provider_11, t0.oauth_id AS oauth_id_12, t0.oauth_access_token AS oauth_access_token_13, t0.oauth_refresh_token AS oauth_refresh_token_14, t0.oauth_token_expires_at AS oauth_token_expires_at_15, t0.referral_code AS referral_code_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"webrivals@gmail.com"
]
|
| 2 | 6.35 ms |
SELECT t0.id AS id_1, t0.jti AS jti_2, t0.ip_address AS ip_address_3, t0.user_agent AS user_agent_4, t0.expires_at AS expires_at_5, t0.is_active AS is_active_6, t0.last_activity_at AS last_activity_at_7, t0.terminated_at AS terminated_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11 FROM user_sessions t0 WHERE t0.jti = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "3dfdd5707cfee9c0fae39c7d2fba1627" 1 ] |
| 3 | 0.32 ms |
SELECT t0.id AS id_1, t0.jti AS jti_2, t0.ip_address AS ip_address_3, t0.user_agent AS user_agent_4, t0.expires_at AS expires_at_5, t0.is_active AS is_active_6, t0.last_activity_at AS last_activity_at_7, t0.terminated_at AS terminated_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11 FROM user_sessions t0 WHERE t0.jti = ? AND t0.is_active = ? LIMIT 1
Parameters:
[ "3dfdd5707cfee9c0fae39c7d2fba1627" 1 ] |
| 4 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.21 ms |
UPDATE user_sessions SET last_activity_at = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-06-02 12:40:29" "2026-06-02 12:40:29" 475 ] |
| 6 | 0.10 ms |
"COMMIT"
Parameters:
[] |
| 7 | 16.21 ms |
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.customer_email AS customer_email_3, t0.amount AS amount_4, t0.status AS status_5, t0.subscription_start_date AS subscription_start_date_6, t0.subscription_end_date AS subscription_end_date_7, t0.currency AS currency_8, t0.stripe_subscription_id AS stripe_subscription_id_9, t0.subscription_status AS subscription_status_10, t0.next_billing_date AS next_billing_date_11, t0.billing_interval AS billing_interval_12, t0.invoice_id AS invoice_id_13, t0.invoice_number AS invoice_number_14, t0.invoice_url AS invoice_url_15, t0.invoice_pdf AS invoice_pdf_16, t0.invoice_status AS invoice_status_17, t0.invoice_amount AS invoice_amount_18, t0.payment_intent_id AS payment_intent_id_19, t0.charge_id AS charge_id_20, t0.receipt_url AS receipt_url_21, t0.invoice_data AS invoice_data_22, t0.cancelled_at AS cancelled_at_23, t0.cancel_at_period_end AS cancel_at_period_end_24, t0.cancel_at AS cancel_at_25, t0.coupon_billing_cycles_remaining AS coupon_billing_cycles_remaining_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.parent_user_id AS parent_user_id_29, t0.applied_coupon_usage_id AS applied_coupon_usage_id_30 FROM subscriptions t0 WHERE t0.parent_user_id = ?
Parameters:
[
35
]
|
| 8 | 0.56 ms |
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.product_code AS product_code_4, t0.subscription_type AS subscription_type_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.subscription_id AS subscription_id_9, t0.user_id AS user_id_10, t0.parent_course_id AS parent_course_id_11 FROM purchaged_products t0 WHERE t0.user_id = ?
Parameters:
[
35
]
|
| 9 | 6.42 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.regular_price AS regular_price_4, t0.sale_price AS sale_price_5, t0.slug AS slug_6, t0.feature_image AS feature_image_7, t0.status AS status_8, t0.total_duration AS total_duration_9, t0.total_lectures AS total_lectures_10, t0.level AS level_11, t0.monthly_price AS monthly_price_12, t0.product_code AS product_code_13, t0.start_date AS start_date_14, t0.end_date AS end_date_15, t0.video_folder AS video_folder_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.category_id AS category_id_19 FROM video_course t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 10 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.vimeo_tag AS vimeo_tag_3, t0.vimeo_folder_id AS vimeo_folder_id_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM category t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 11 | 0.35 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.regular_price AS regular_price_4, t0.sale_price AS sale_price_5, t0.slug AS slug_6, t0.feature_image AS feature_image_7, t0.status AS status_8, t0.total_duration AS total_duration_9, t0.total_lectures AS total_lectures_10, t0.level AS level_11, t0.monthly_price AS monthly_price_12, t0.product_code AS product_code_13, t0.start_date AS start_date_14, t0.end_date AS end_date_15, t0.video_folder AS video_folder_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.category_id AS category_id_19 FROM video_course 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\Subscription | 2 |
| App\Entity\PurchagedProducts | 2 |
| App\Entity\VideoCourse | 2 |
| App\Entity\User | 1 |
| App\Entity\UserSession | 1 |
| App\Entity\Category | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\PurchagedProducts | No errors. |
| App\Entity\UserSession | No errors. |
| App\Entity\CouponUsage |
|
| App\Entity\VideoCourse | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Video | No errors. |