Query Metrics
4
Database Queries
4
Different statements
1.65 ms
Query time
0
Invalid entities
6
Managed entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.47 ms |
SELECT s0_.name AS name_0, s0_.duration_months AS duration_months_1, s0_.price AS price_2, s0_.currency AS currency_3, s0_.features AS features_4, s0_.original_price AS original_price_5, s0_.badge AS badge_6, s0_.is_popular AS is_popular_7, s0_.offer_expires_at AS offer_expires_at_8, s0_.id AS id_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.is_enabled AS is_enabled_12, s0_.position AS position_13, s0_.last_position AS last_position_14 FROM subscription_plan s0_ WHERE (s0_.is_enabled = ?) AND (s0_.is_enabled = '1') ORDER BY s0_.position ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.27 ms |
SELECT t0.full_name AS full_name_1, t0.phone_number AS phone_number_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t6.language AS language_7, t6.marketing_opt_in AS marketing_opt_in_8, t6.push_enabled AS push_enabled_9, t6.email_enabled AS email_enabled_10, t6.created_at AS created_at_11, t6.updated_at AS updated_at_12, t6.profile_id AS profile_id_13, t0.user_id AS user_id_14 FROM user_profile t0 LEFT JOIN user_profile_preferences t6 ON t6.profile_id = t0.id WHERE t0.user_id = ? LIMIT 1
Parameters:
[
b"\x01›´¬1Ëp·£±Ä»„\x06{â"
]
|
||||||||||||||||||||||||||||||||
| 3 | 0.28 ms |
SELECT e0_.status AS status_0, e0_.score AS score_1, e0_.passing_score AS passing_score_2, e0_.passed AS passed_3, e0_.started_at AS started_at_4, e0_.completed_at AS completed_at_5, e0_.duration_seconds AS duration_seconds_6, e0_.questions AS questions_7, e0_.answers AS answers_8, e0_.id AS id_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, e0_.user_id AS user_id_12 FROM examination_exam_simulation e0_ WHERE e0_.user_id = ? AND e0_.created_at >= ? AND e0_.created_at < ?
Parameters:
[ b"\x01›´¬1Ëp·£±Ä»„\x06{â" "2026-01-13 00:00:00" "2026-01-14 00:00:00" ]
|
||||||||||||||||||||||||||||||||
| 4 | 0.63 ms |
SELECT l0_.name AS name_0, l0_.description AS description_1, l0_.is_free AS is_free_2, l0_.is_primary AS is_primary_3, l0_.quota AS quota_4, l0_.id AS id_5, l0_.created_at AS created_at_6, l0_.updated_at AS updated_at_7, l0_.slug AS slug_8, l0_.position AS position_9, l0_.last_position AS last_position_10, l0_.is_enabled AS is_enabled_11, l0_.parent_id AS parent_id_12 FROM learning_theme l0_ WHERE (l0_.is_primary = ? AND l0_.quota > 0 AND l0_.is_enabled = ?) AND (l0_.is_enabled = '1') ORDER BY l0_.position ASC
Parameters:
[ 1 1 ]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
0
Hits
0
Misses
0
Puts
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Subscription\Plan | 3 |
| App\Entity\Access\UserProfile\UserProfile | 1 |
| App\Entity\Access\Identity | 1 |
| App\Entity\Access\UserProfile\UserProfilePreferences | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Subscription\Plan | No errors. |
| App\Entity\Subscription\Subscription | No errors. |
| App\Entity\Access\UserProfile\UserProfile | No errors. |
| App\Entity\Access\UserProfile\UserProfilePreferences | No errors. |
| App\Entity\Access\Identity | No errors. |
| App\Entity\Examination\ExamSimulation | No errors. |
| App\Entity\Learning\Theme | No errors. |