Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.98 ms Query time

4 Invalid entities

49 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	0.36 ms	SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.firstname AS firstname_12, t0.lastname AS lastname_13, t0.mobile AS mobile_14, t0.sex AS sex_15, t0.roles AS roles_16, t0.picture AS picture_17, t0.slug AS slug_18, t0.password_expired AS password_expired_19, t0.anonymized AS anonymized_20, t0.optin AS optin_21, t0.recycle_status AS recycle_status_22, t0.recycle_start_at AS recycle_start_at_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.idv1 AS idv1_26, t0.admin_role_id AS admin_role_id_27 FROM user t0 WHERE t0.id = ? Parameters: [`17990`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.firstname AS firstname_12, t0.lastname AS lastname_13, t0.mobile AS mobile_14, t0.sex AS sex_15, t0.roles AS roles_16, t0.picture AS picture_17, t0.slug AS slug_18, t0.password_expired AS password_expired_19, t0.anonymized AS anonymized_20, t0.optin AS optin_21, t0.recycle_status AS recycle_status_22, t0.recycle_start_at AS recycle_start_at_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.idv1 AS idv1_26, t0.admin_role_id AS admin_role_id_27 FROM user t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.firstname AS firstname_12, t0.lastname AS lastname_13, t0.mobile AS mobile_14, t0.sex AS sex_15, t0.roles AS roles_16, t0.picture AS picture_17, t0.slug AS slug_18, t0.password_expired AS password_expired_19, t0.anonymized AS anonymized_20, t0.optin AS optin_21, t0.recycle_status AS recycle_status_22, t0.recycle_start_at AS recycle_start_at_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.idv1 AS idv1_26, t0.admin_role_id AS admin_role_id_27 FROM user t0 WHERE t0.id = 17990;
2	0.40 ms	SELECT t0.id AS id_1, t0.job AS job_2, t0.about_you AS about_you_3, t0.about_your_job AS about_your_job_4, t0.about_your_formation AS about_your_formation_5, t0.about_your_offer AS about_your_offer_6, t0.my_address_enabled AS my_address_enabled_7, t0.itdlc_number AS itdlc_number_8, t0.itdlc_distance_max AS itdlc_distance_max_9, t0.available AS available_10, t0.available_at AS available_at_11, t0.context_available AS context_available_12, t0.nb_itdlc_archived AS nb_itdlc_archived_13, t0.nb_itdlc_refused_by_speaker_current_year AS nb_itdlc_refused_by_speaker_current_year_14, t0.nb_itdlc_aborted_by_speaker_current_year AS nb_itdlc_aborted_by_speaker_current_year_15, t0.nb_successive_non_response AS nb_successive_non_response_16, t0.last_registration_step AS last_registration_step_17, t0.available_date_updated AS available_date_updated_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.status AS status_21, t0.comment AS comment_22, t0.idv1 AS idv1_23, t0.user_id AS user_id_24, t0.education_level_id AS education_level_id_25, t0.my_address_id AS my_address_id_26, t0.current_address_id AS current_address_id_27, t0.company_location_id AS company_location_id_28 FROM speaker t0 WHERE t0.user_id = ? LIMIT 1 Parameters: [`17990`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.job AS job_2, t0.about_you AS about_you_3, t0.about_your_job AS about_your_job_4, t0.about_your_formation AS about_your_formation_5, t0.about_your_offer AS about_your_offer_6, t0.my_address_enabled AS my_address_enabled_7, t0.itdlc_number AS itdlc_number_8, t0.itdlc_distance_max AS itdlc_distance_max_9, t0.available AS available_10, t0.available_at AS available_at_11, t0.context_available AS context_available_12, t0.nb_itdlc_archived AS nb_itdlc_archived_13, t0.nb_itdlc_refused_by_speaker_current_year AS nb_itdlc_refused_by_speaker_current_year_14, t0.nb_itdlc_aborted_by_speaker_current_year AS nb_itdlc_aborted_by_speaker_current_year_15, t0.nb_successive_non_response AS nb_successive_non_response_16, t0.last_registration_step AS last_registration_step_17, t0.available_date_updated AS available_date_updated_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.status AS status_21, t0.comment AS comment_22, t0.idv1 AS idv1_23, t0.user_id AS user_id_24, t0.education_level_id AS education_level_id_25, t0.my_address_id AS my_address_id_26, t0.current_address_id AS current_address_id_27, t0.company_location_id AS company_location_id_28 FROM speaker t0 WHERE t0.user_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.job AS job_2, t0.about_you AS about_you_3, t0.about_your_job AS about_your_job_4, t0.about_your_formation AS about_your_formation_5, t0.about_your_offer AS about_your_offer_6, t0.my_address_enabled AS my_address_enabled_7, t0.itdlc_number AS itdlc_number_8, t0.itdlc_distance_max AS itdlc_distance_max_9, t0.available AS available_10, t0.available_at AS available_at_11, t0.context_available AS context_available_12, t0.nb_itdlc_archived AS nb_itdlc_archived_13, t0.nb_itdlc_refused_by_speaker_current_year AS nb_itdlc_refused_by_speaker_current_year_14, t0.nb_itdlc_aborted_by_speaker_current_year AS nb_itdlc_aborted_by_speaker_current_year_15, t0.nb_successive_non_response AS nb_successive_non_response_16, t0.last_registration_step AS last_registration_step_17, t0.available_date_updated AS available_date_updated_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.status AS status_21, t0.comment AS comment_22, t0.idv1 AS idv1_23, t0.user_id AS user_id_24, t0.education_level_id AS education_level_id_25, t0.my_address_id AS my_address_id_26, t0.current_address_id AS current_address_id_27, t0.company_location_id AS company_location_id_28 FROM speaker t0 WHERE t0.user_id = 17990 LIMIT 1;
3	0.22 ms	SELECT a0_.id AS id_0, a0_.label AS label_1 FROM activity_area a0_ ORDER BY a0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.label AS label_1 FROM activity_area a0_ ORDER BY a0_.id ASC SELECT a0_.id AS id_0, a0_.label AS label_1 FROM activity_area a0_ ORDER BY a0_.id ASC;

#▲

Time

Info

0.36 ms

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.firstname AS firstname_12, t0.lastname AS lastname_13, t0.mobile AS mobile_14, t0.sex AS sex_15, t0.roles AS roles_16, t0.picture AS picture_17, t0.slug AS slug_18, t0.password_expired AS password_expired_19, t0.anonymized AS anonymized_20, t0.optin AS optin_21, t0.recycle_status AS recycle_status_22, t0.recycle_start_at AS recycle_start_at_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.idv1 AS idv1_26, t0.admin_role_id AS admin_role_id_27 FROM user t0 WHERE t0.id = ?

Parameters:

[
  17990
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.username_canonical AS username_canonical_3,
  t0.email AS email_4,
  t0.email_canonical AS email_canonical_5,
  t0.enabled AS enabled_6,
  t0.salt AS salt_7,
  t0.password AS password_8,
  t0.last_login AS last_login_9,
  t0.confirmation_token AS confirmation_token_10,
  t0.password_requested_at AS password_requested_at_11,
  t0.firstname AS firstname_12,
  t0.lastname AS lastname_13,
  t0.mobile AS mobile_14,
  t0.sex AS sex_15,
  t0.roles AS roles_16,
  t0.picture AS picture_17,
  t0.slug AS slug_18,
  t0.password_expired AS password_expired_19,
  t0.anonymized AS anonymized_20,
  t0.optin AS optin_21,
  t0.recycle_status AS recycle_status_22,
  t0.recycle_start_at AS recycle_start_at_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.idv1 AS idv1_26,
  t0.admin_role_id AS admin_role_id_27
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.firstname AS firstname_12, t0.lastname AS lastname_13, t0.mobile AS mobile_14, t0.sex AS sex_15, t0.roles AS roles_16, t0.picture AS picture_17, t0.slug AS slug_18, t0.password_expired AS password_expired_19, t0.anonymized AS anonymized_20, t0.optin AS optin_21, t0.recycle_status AS recycle_status_22, t0.recycle_start_at AS recycle_start_at_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.idv1 AS idv1_26, t0.admin_role_id AS admin_role_id_27 FROM user t0 WHERE t0.id = 17990;

0.40 ms

SELECT t0.id AS id_1, t0.job AS job_2, t0.about_you AS about_you_3, t0.about_your_job AS about_your_job_4, t0.about_your_formation AS about_your_formation_5, t0.about_your_offer AS about_your_offer_6, t0.my_address_enabled AS my_address_enabled_7, t0.itdlc_number AS itdlc_number_8, t0.itdlc_distance_max AS itdlc_distance_max_9, t0.available AS available_10, t0.available_at AS available_at_11, t0.context_available AS context_available_12, t0.nb_itdlc_archived AS nb_itdlc_archived_13, t0.nb_itdlc_refused_by_speaker_current_year AS nb_itdlc_refused_by_speaker_current_year_14, t0.nb_itdlc_aborted_by_speaker_current_year AS nb_itdlc_aborted_by_speaker_current_year_15, t0.nb_successive_non_response AS nb_successive_non_response_16, t0.last_registration_step AS last_registration_step_17, t0.available_date_updated AS available_date_updated_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.status AS status_21, t0.comment AS comment_22, t0.idv1 AS idv1_23, t0.user_id AS user_id_24, t0.education_level_id AS education_level_id_25, t0.my_address_id AS my_address_id_26, t0.current_address_id AS current_address_id_27, t0.company_location_id AS company_location_id_28 FROM speaker t0 WHERE t0.user_id = ? LIMIT 1

Parameters:

[
  17990
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.job AS job_2,
  t0.about_you AS about_you_3,
  t0.about_your_job AS about_your_job_4,
  t0.about_your_formation AS about_your_formation_5,
  t0.about_your_offer AS about_your_offer_6,
  t0.my_address_enabled AS my_address_enabled_7,
  t0.itdlc_number AS itdlc_number_8,
  t0.itdlc_distance_max AS itdlc_distance_max_9,
  t0.available AS available_10,
  t0.available_at AS available_at_11,
  t0.context_available AS context_available_12,
  t0.nb_itdlc_archived AS nb_itdlc_archived_13,
  t0.nb_itdlc_refused_by_speaker_current_year AS nb_itdlc_refused_by_speaker_current_year_14,
  t0.nb_itdlc_aborted_by_speaker_current_year AS nb_itdlc_aborted_by_speaker_current_year_15,
  t0.nb_successive_non_response AS nb_successive_non_response_16,
  t0.last_registration_step AS last_registration_step_17,
  t0.available_date_updated AS available_date_updated_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.status AS status_21,
  t0.comment AS comment_22,
  t0.idv1 AS idv1_23,
  t0.user_id AS user_id_24,
  t0.education_level_id AS education_level_id_25,
  t0.my_address_id AS my_address_id_26,
  t0.current_address_id AS current_address_id_27,
  t0.company_location_id AS company_location_id_28
FROM
  speaker t0
WHERE
  t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.job AS job_2, t0.about_you AS about_you_3, t0.about_your_job AS about_your_job_4, t0.about_your_formation AS about_your_formation_5, t0.about_your_offer AS about_your_offer_6, t0.my_address_enabled AS my_address_enabled_7, t0.itdlc_number AS itdlc_number_8, t0.itdlc_distance_max AS itdlc_distance_max_9, t0.available AS available_10, t0.available_at AS available_at_11, t0.context_available AS context_available_12, t0.nb_itdlc_archived AS nb_itdlc_archived_13, t0.nb_itdlc_refused_by_speaker_current_year AS nb_itdlc_refused_by_speaker_current_year_14, t0.nb_itdlc_aborted_by_speaker_current_year AS nb_itdlc_aborted_by_speaker_current_year_15, t0.nb_successive_non_response AS nb_successive_non_response_16, t0.last_registration_step AS last_registration_step_17, t0.available_date_updated AS available_date_updated_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.status AS status_21, t0.comment AS comment_22, t0.idv1 AS idv1_23, t0.user_id AS user_id_24, t0.education_level_id AS education_level_id_25, t0.my_address_id AS my_address_id_26, t0.current_address_id AS current_address_id_27, t0.company_location_id AS company_location_id_28 FROM speaker t0 WHERE t0.user_id = 17990 LIMIT 1;

0.22 ms

SELECT a0_.id AS id_0, a0_.label AS label_1 FROM activity_area a0_ ORDER BY a0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  a0_.id AS id_0,
  a0_.label AS label_1
FROM
  activity_area a0_
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.label AS label_1 FROM activity_area a0_ ORDER BY a0_.id ASC;

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\ActivityArea	46
App\Entity\User	1
App\Entity\Speaker	1
App\Entity\Address	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\AdminRole	No errors.
App\Entity\ManagerOrganisation	No errors.
App\Entity\UserPreference	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\Feedback	No errors.
App\Entity\UserLog	No errors.
App\Entity\Company	No errors.
App\Entity\CompanyLocation	No errors.
App\Entity\EducationItem	The association App\Entity\EducationItem#speaker refers to the inverse side field App\Entity\Speaker#educationItems which does not exist.
App\Entity\Speaker	No errors.
App\Entity\Itdlc	No errors.
App\Entity\JobHistoryItem	The association App\Entity\JobHistoryItem#speaker refers to the inverse side field App\Entity\Speaker#jobHistoryItems which does not exist.
App\Entity\Manager	No errors.
App\Entity\School	No errors.
App\Entity\Tag	The association App\Entity\Tag#speakers refers to the inverse side field App\Entity\Speaker#tags which does not exist. The association App\Entity\Tag#teachers refers to the inverse side field App\Entity\Teacher#tags which does not exist.
App\Entity\TagList	No errors.
App\Entity\EducationLevel	No errors.
App\Entity\Address	No errors.
App\Entity\ClassLevel	The field App\Entity\ClassLevel#teachers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Teacher#classLevels does not contain the required 'inversedBy="teachers"' attribute.
App\Entity\SpeechType	No errors.
App\Entity\ActivityArea	No errors.
App\Entity\Pee	No errors.

Symfony Profiler

POST https://quentinribac-cgenial/api/graphql

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping