http://academy.cofinaonline.com/dashboard/apprenant/notifications

Query Metrics

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

Queries

Group similar statements

# Time Info
1 7.53 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login_at AS last_login_at_5, t0.last_logout_at AS last_logout_at_6, t0.description AS description_7, t0.lastname AS lastname_8, t0.firstname AS firstname_9, t0.is_first_connexion AS is_first_connexion_10, t0.registration_number AS registration_number_11, t0.hierarchical_level AS hierarchical_level_12, t0.phone_number AS phone_number_13, t0.status AS status_14, t0.active AS active_15, t0.referent AS referent_16, t0.entry_date AS entry_date_17, t0.activation_code AS activation_code_18, t0.activation_code_expired_at AS activation_code_expired_at_19, t0.reset_code AS reset_code_20, t0.reset_code_expired_at AS reset_code_expired_at_21, t0.device_tokens AS device_tokens_22, t0.is_verified AS is_verified_23, t0.profile_color AS profile_color_24, t0.is_internal_account AS is_internal_account_25, t0.elapsed_time AS elapsed_time_26, t0.last_login_notified_at AS last_login_notified_at_27, t0.country_id AS country_id_28, t0.module_id AS module_id_29, t0.subsidiary_company_id AS subsidiary_company_id_30, t0.job_id AS job_id_31, t0.office_id AS office_id_32, t0.contract_id AS contract_id_33, t0.photo_id AS photo_id_34, t0.responsible_id AS responsible_id_35 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  3758
]
2 7.42 ms
SELECT COUNT(n0_.id) AS sclr_0 FROM notification n0_ LEFT JOIN notification_receiver n1_ ON n0_.id = n1_.notification_id WHERE ((n0_.receiver_id = ? AND n1_.id IS NULL) AND (n0_.is_read IS NULL OR n0_.is_read = 0)) OR (n1_.receiver_id = ? AND (n1_.is_read IS NULL OR n1_.is_read = 0)) LIMIT 1
Parameters:
[
  3758
  3758
]
3 7.47 ms
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.message AS message_2, n0_.object_type AS object_type_3, n0_.object_id AS object_id_4, n0_.is_read AS is_read_5, n0_.topics AS topics_6, n0_.action AS action_7, n0_.created_at AS created_at_8, n0_.updated_at AS updated_at_9, n1_.id AS id_10, n1_.read_at AS read_at_11, n1_.topics AS topics_12, n1_.created_at AS created_at_13, n1_.is_read AS is_read_14, n0_.receiver_id AS receiver_id_15, n0_.comment_id AS comment_id_16, n0_.module_id AS module_id_17, n0_.subject_id AS subject_id_18, n0_.created_by AS created_by_19, n1_.notification_id AS notification_id_20, n1_.receiver_id AS receiver_id_21 FROM notification n0_ LEFT JOIN notification_receiver n1_ ON n0_.id = n1_.notification_id AND (n1_.receiver_id = ?) WHERE (n0_.receiver_id = ? AND n1_.id IS NULL) OR n1_.receiver_id = ? ORDER BY n0_.created_at DESC LIMIT 12
Parameters:
[
  3758
  3758
  3758
]
4 7.47 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login_at AS last_login_at_5, t0.last_logout_at AS last_logout_at_6, t0.description AS description_7, t0.lastname AS lastname_8, t0.firstname AS firstname_9, t0.is_first_connexion AS is_first_connexion_10, t0.registration_number AS registration_number_11, t0.hierarchical_level AS hierarchical_level_12, t0.phone_number AS phone_number_13, t0.status AS status_14, t0.active AS active_15, t0.referent AS referent_16, t0.entry_date AS entry_date_17, t0.activation_code AS activation_code_18, t0.activation_code_expired_at AS activation_code_expired_at_19, t0.reset_code AS reset_code_20, t0.reset_code_expired_at AS reset_code_expired_at_21, t0.device_tokens AS device_tokens_22, t0.is_verified AS is_verified_23, t0.profile_color AS profile_color_24, t0.is_internal_account AS is_internal_account_25, t0.elapsed_time AS elapsed_time_26, t0.last_login_notified_at AS last_login_notified_at_27, t0.country_id AS country_id_28, t0.module_id AS module_id_29, t0.subsidiary_company_id AS subsidiary_company_id_30, t0.job_id AS job_id_31, t0.office_id AS office_id_32, t0.contract_id AS contract_id_33, t0.photo_id AS photo_id_34, t0.responsible_id AS responsible_id_35 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  680
]
5 7.39 ms
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.file_size AS file_size_3, t0.updated_at AS updated_at_4 FROM image_manager t0 WHERE t0.id = ?
Parameters:
[
  282
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User
  • The field App\Entity\User#moduleViews is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ModuleView#createdBy does not contain the required 'inversedBy="moduleViews"' attribute.
  • The field App\Entity\User#module is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Module#coaches does not contain the required 'mappedBy="module"' attribute.
  • If association App\Entity\User#module is many-to-one, then the inversed side App\Entity\Module#coaches has to be one-to-many.
  • The association App\Entity\User#userQuizQuestions refers to the owning side field App\Entity\UserQuizQuestion#user which does not exist.
  • The field App\Entity\User#programParticipations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProgramParticipation#createdBy does not contain the required 'inversedBy="programParticipations"' attribute.
  • The field App\Entity\User#moduleParticipations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ModuleParticipation#createdBy does not contain the required 'inversedBy="moduleParticipations"' attribute.
  • The field App\Entity\User#senderDiscussions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Discussion#createdBy does not contain the required 'inversedBy="senderDiscussions"' attribute.
  • The field App\Entity\User#receiverDiscussions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Discussion#receiver does not contain the required 'inversedBy="receiverDiscussions"' attribute.
  • The field App\Entity\User#messages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Message#createdBy does not contain the required 'inversedBy="messages"' attribute.
  • The field App\Entity\User#userModuleParticipations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserModuleParticipation#createdBy does not contain the required 'inversedBy="userModuleParticipations"' attribute.
App\Entity\Country No errors.
App\Entity\BaseEntity No errors.
App\Entity\Module No errors.
App\Entity\SubsidiaryCompany
  • The association App\Entity\SubsidiaryCompany#offices refers to the inverse side field App\Entity\Office#subsidiaryCompanies which does not exist.
App\Entity\Job No errors.
App\Entity\Office No errors.
App\Entity\Contract No errors.
App\Entity\ImageManager No errors.
App\Entity\UserOffice No errors.
App\Entity\Experience No errors.
App\Entity\Course No errors.
App\Entity\Role No errors.
App\Entity\Enrollment No errors.
App\Entity\ModuleView No errors.
App\Entity\ModuleLike No errors.
App\Entity\UserQuizQuestion No errors.
App\Entity\Quote No errors.
App\Entity\Director No errors.
App\Entity\Live No errors.
App\Entity\LiveParticipant No errors.
App\Entity\ModuleComment No errors.
App\Entity\ProgramParticipation No errors.
App\Entity\ModuleParticipation No errors.
App\Entity\ModuleInscription No errors.
App\Entity\Discussion No errors.
App\Entity\Message
  • The mappings App\Entity\Message#receiver and App\Entity\User#messages are inconsistent with each other.
App\Entity\Program No errors.
App\Entity\UserModuleParticipation No errors.
App\Entity\Notification No errors.
App\Entity\NotificationReceiver No errors.
App\Entity\Comment No errors.
App\Entity\Subject No errors.