http://academy.cofinaonline.com/bibliotheque/update-elapsed-time Return to referer URL

Query Metrics

4 Database Queries
4 Different statements
22.54 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
9.09 ms
(40.32%)
1
"COMMIT"
Parameters:
[]
4.73 ms
(20.97%)
1
UPDATE `user` SET elapsed_time = ? WHERE id = ?
Parameters:
[
  4998
  3756
]
4.38 ms
(19.42%)
1
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:
[
  3756
]
4.35 ms
(19.29%)
1
"START TRANSACTION"
Parameters:
[]

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\Partenaire No errors.