GET https://karbontrail.fr/trail/audit/205/142/efficience/premier-questionnaire/

Query Metrics

1 Database Queries
1 Different statements
2.41 ms Query time
4 Invalid entities
3 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.41 ms
(100.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.password AS password_4, t0.roles AS roles_5, t0.slug AS slug_6, t0.adress AS adress_7, t0.code_postal AS code_postal_8, t0.city AS city_9, t0.tel AS tel_10, t0.audit_notify_status AS audit_notify_status_11, t0.naf AS naf_12, t0.siren AS siren_13, t0.is_certified AS is_certified_14, t0.is_verified AS is_verified_15, t0.password_token AS password_token_16, t0.password_token_expiration AS password_token_expiration_17, t0.profil_image_id AS profil_image_id_18, t19.id AS id_20, t19.is_elligible AS is_elligible_21, t19.entreprise_id AS entreprise_id_22, t23.id AS id_24, t23.token AS token_25, t23.is_verified AS is_verified_26, t23.created_at AS created_at_27, t23.expires_at AS expires_at_28, t23.entreprise_id AS entreprise_id_29, t0.audit_version_id AS audit_version_id_30, t31.id AS id_32, t31.nom AS nom_33, t31.prenom AS prenom_34, t31.email AS email_35, t31.tel AS tel_36, t31.role AS role_37, t31.entreprise_id AS entreprise_id_38, t0.bureau_etude_id AS bureau_etude_id_39 FROM entreprise t0 LEFT JOIN pre_requis t19 ON t19.entreprise_id = t0.id LEFT JOIN verification_mail t23 ON t23.entreprise_id = t0.id LEFT JOIN entreprise_main_contact t31 ON t31.entreprise_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "205"
]

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\Entreprise 1
App\Entity\AuditVersion 1
App\Entity\VerificationMail 1

Entities Mapping

Class Mapping errors
App\Entity\Entreprise No errors.
App\Entity\EntrepriseImage No errors.
App\Entity\PreRequis
  • The mappings App\Entity\PreRequis#preRequisReponses and App\Entity\PreRequisReponse#pre_requis are inconsistent with each other.
App\Entity\VerificationMail No errors.
App\Entity\AuditVersion
  • The field App\Entity\AuditVersion#piliers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Pilier#auditVersion does not contain the required 'inversedBy="piliers"' attribute.
App\Entity\EntrepriseMainContact No errors.
App\Entity\StudyOffice No errors.
App\Entity\EntrepriseMembers No errors.
App\Entity\Audit No errors.
App\Entity\Jalon
  • The association App\Entity\Jalon#action refers to the inverse side field App\Entity\Action#jalons which does not exist.
App\Entity\StaffKarbon
  • The field App\Entity\StaffKarbon#audits_to_verify is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Audit#verificateur does not contain the required 'inversedBy="audits_to_verify"' attribute.
  • The field App\Entity\StaffKarbon#verifications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Audit#verificateur does not contain the required 'inversedBy="verifications"' attribute.
  • The association App\Entity\StaffKarbon#reponseTicket refers to the inverse side field App\Entity\ReponseTicket#staffKarbon which does not exist.
App\Entity\Ticket No errors.
App\Entity\Objectif No errors.