Query Metrics
5
Database Queries
4
Different statements
6.11 ms
Query time
3
Invalid entities
4
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.44 ms (39.87%) |
1 |
SELECT t0.id AS id_1, t0.day AS day_2, t0.time AS time_3, t0.price AS price_4, t0.room_name AS room_name_5, t0.room_pass AS room_pass_6, t0.category_index AS category_index_7, t0.description AS description_8, t0.coach_id AS coach_id_9 FROM `group` t0 ORDER BY t0.day ASC
Parameters:
[] |
|
1.98 ms (32.38%) |
2 |
SELECT t0.id AS id_1, t0.stripe_subscription_id AS stripe_subscription_id_2, t0.active AS active_3, t0.customer_id AS customer_id_4, t0.session_group_id AS session_group_id_5 FROM subscription t0 WHERE t0.session_group_id = ?
Parameters:
[
1
]
|
|
1.11 ms (18.10%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.picture AS picture_7, t0.picture_size AS picture_size_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.is_verified AS is_verified_11, t0.street AS street_12, t0.phone AS phone_13, t0.complement AS complement_14, t0.zipcode AS zipcode_15, t0.city AS city_16, t0.country AS country_17, t0.login AS login_18, t19.id AS id_20, t19.credit AS credit_21, t19.stripe_id AS stripe_id_22, t19.subscription_id AS subscription_id_23, t19.payment_count AS payment_count_24, t19.shopping AS shopping_25, t19.access_type AS access_type_26, t19.is_final_test_done AS is_final_test_done_27, t19.user_id AS user_id_28, t19.referer_id AS referer_id_29, t30.id AS id_31, t30.iban AS iban_32, t30.phone AS phone_33, t30.intro AS intro_34, t30.method AS method_35, t30.diplomas AS diplomas_36, t30.idcode AS idcode_37, t30.stripe_id AS stripe_id_38, t30.stripe_validated AS stripe_validated_39, t30.user_id AS user_id_40 FROM user t0 LEFT JOIN customer t19 ON t19.user_id = t0.id LEFT JOIN coach t30 ON t30.user_id = t0.id WHERE t0.id = ?
Parameters:
[
754
]
|
|
0.59 ms (9.64%) |
1 |
SELECT t0.id AS id_1, t0.iban AS iban_2, t0.phone AS phone_3, t0.intro AS intro_4, t0.method AS method_5, t0.diplomas AS diplomas_6, t0.idcode AS idcode_7, t0.stripe_id AS stripe_id_8, t0.stripe_validated AS stripe_validated_9, t0.user_id AS user_id_10 FROM coach 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\Group | 2 |
| App\Entity\Coach | 1 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Group |
|
| App\Entity\Coach | No errors. |
| App\Entity\Subscription |
|
| App\Entity\Customer |
|
| App\Entity\User | No errors. |
| App\Entity\Session | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\StatTag | No errors. |