Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

2.71 ms Query time

2 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	1.29 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: [`1`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
2	0.57 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 Parameters: [] View formatted query View runnable query Explain query 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 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;
3	0.85 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`] View formatted query View runnable query Explain query 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 = ? 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 = 754;

#▲

Time

Info

1.29 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:

[
  1
]

View formatted query View runnable query Explain query

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 = ?

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 = 1;

0.57 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

Parameters:

[]

View formatted query View runnable query Explain query

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

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;

0.85 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
]

View formatted query View runnable query Explain query

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 = ?

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 = 754;

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	2
App\Entity\Coach	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
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\Coach	No errors.
App\Entity\Session	No errors.
App\Entity\Order	No errors.
App\Entity\Notification	No errors.
App\Entity\StatTag	No errors.
App\Entity\Group	The association App\Entity\Group#coach refers to the inverse side field App\Entity\Coach#groups which does not exist.

Symfony Profiler

GET https://app.takadoc.eu/create?p=create

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping