Query Metrics

10 Database Queries
9 Different statements
4.14 ms Query time
1 Invalid entities
15 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.35 ms
(32.51%)
1
SELECT t0.id AS id_1, t0.occure_at AS occure_at_2, t0.start_at AS start_at_3, t0.finish_at AS finish_at_4, t0.status AS status_5, t0.itdlc_id AS itdlc_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM itdlc_option_date t0 WHERE t0.itdlc_id = ?
Parameters:
[
  5811
]
0.65 ms
(15.66%)
2
SELECT COUNT(*) FROM notification t0 WHERE t0.recipient_id = ? AND t0.status = ? AND t0.channel = ?
Parameters:
[
  22608
  "sent"
  "notification.channel.plateform"
]
0.47 ms
(11.30%)
1
SELECT i0_.id AS id_0, i0_.student_number AS student_number_1, i0_.female_student_number AS female_student_number_2, i0_.male_student_number AS male_student_number_3, i0_.description AS description_4, i0_.occure_at AS occure_at_5, i0_.start_at AS start_at_6, i0_.finish_at AS finish_at_7, i0_.statued_by_role AS statued_by_role_8, i0_.review_teacher_status AS review_teacher_status_9, i0_.review_speaker_status AS review_speaker_status_10, i0_.reason_acceptance AS reason_acceptance_11, i0_.reason_proposal AS reason_proposal_12, i0_.reason_refusal AS reason_refusal_13, i0_.type AS type_14, i0_.class_level_name AS class_level_name_15, i0_.process_updated_at AS process_updated_at_16, i0_.reported AS reported_17, i0_.created_at AS created_at_18, i0_.updated_at AS updated_at_19, i0_.status AS status_20, i0_.comment AS comment_21, i0_.speaker_id AS speaker_id_22, i0_.teacher_id AS teacher_id_23, i0_.teacher_school_id AS teacher_school_id_24, i0_.class_level_id AS class_level_id_25, i0_.speech_type_id AS speech_type_id_26, i0_.address_id AS address_id_27, i0_.duplicated_from_id AS duplicated_from_id_28 FROM itdlc i0_ WHERE i0_.id = ? AND i0_.status <> ?
Parameters:
[
  5811
  "edit"
]
0.42 ms
(10.21%)
1
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:
[
  22608
]
0.33 ms
(8.06%)
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.id = ?
Parameters:
[
  2199
]
0.26 ms
(6.27%)
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 = ? LIMIT 1
Parameters:
[
  22608
]
0.25 ms
(6.01%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4, t0.company_id AS company_id_5, t0.company_location_id AS company_location_id_6, t0.corporation_id AS corporation_id_7 FROM manager t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  22608
]
0.22 ms
(5.21%)
1
SELECT t0.id AS id_1, t0.shoe_size AS shoe_size_2, t0.top_size AS top_size_3, t0.bottom_size AS bottom_size_4, t0.teacher_job_more AS teacher_job_more_5, t0.head AS head_6, t0.count_itdlc AS count_itdlc_7, t0.count_itdlc_archived AS count_itdlc_archived_8, t0.count_itdlc_accepted AS count_itdlc_accepted_9, t0.count_itdlc_aborted_by_teacher AS count_itdlc_aborted_by_teacher_10, t0.count_itdlc_refused_by_teacher AS count_itdlc_refused_by_teacher_11, t0.count_pee_subscription AS count_pee_subscription_12, t0.count_pee_subscription_came AS count_pee_subscription_came_13, t0.count_pee_subscription_no_came AS count_pee_subscription_no_came_14, t0.count_pee_subscription_aborted AS count_pee_subscription_aborted_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.status AS status_18, t0.idv1 AS idv1_19, t0.comment AS comment_20, t0.user_id AS user_id_21, t0.teacher_job_id AS teacher_job_id_22, t0.default_teacher_school_id AS default_teacher_school_id_23 FROM teacher t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  22608
]
0.20 ms
(4.76%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.user_id AS user_id_4, t0.organisation_id AS organisation_id_5 FROM manager_organisation t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  22608
]

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\ItdlcOptionDate 3
App\Entity\User 2
App\Entity\Address 2
App\Entity\Itdlc 1
App\Entity\Speaker 1
App\Entity\Teacher 1
App\Entity\TeacherSchool 1
App\Entity\ClassLevel 1
App\Entity\SpeechType 1
App\Entity\EducationLevel 1
App\Entity\CompanyLocation 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\Itdlc No errors.
App\Entity\Speaker No errors.
App\Entity\Teacher No errors.
App\Entity\TeacherSchool 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\Address No errors.
App\Entity\ItdlcOptionDate No errors.
App\Entity\ProcessLog No errors.
App\Entity\EducationLevel No errors.
App\Entity\CompanyLocation No errors.
App\Entity\Notification No errors.
App\Entity\Manager No errors.
App\Entity\Company No errors.
App\Entity\Corporation No errors.
App\Entity\Organisation No errors.
App\Entity\TeacherJob No errors.