GET https://app.takadoc.eu/session/groupe?p=session%2Fgroupe

Query Metrics

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

Queries

Group similar statements

# Time Info
1 2.44 ms
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:
[]
2 1.44 ms
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
]
3 0.59 ms
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
]
4 1.11 ms
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
]
5 0.54 ms
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:
[
  2
]

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
  • The association App\Entity\Group#coach refers to the inverse side field App\Entity\Coach#groups which does not exist.
App\Entity\Coach No errors.
App\Entity\Subscription
  • The association App\Entity\Subscription#customer refers to the inverse side field App\Entity\Customer#subscriptions which does not exist.
App\Entity\Customer
  • The association App\Entity\Customer#evaluationTCAs refers to the owning side field App\Entity\TCAMeteo#user which does not exist.
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.