https://dimawork.fr/mission/details/339

Method
GET
HTTP Status
200
IP
18.225.98.190
Profiled on
Token
75ddcb

Query Metrics

2 Database Queries
2 Different statements
3.45 ms Query time
5 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.89 ms 
SELECT t0.id AS id_1, t0.entreprise_concernee AS entreprise_concernee_2, t0.contexte AS contexte_3, t0.objectifs AS objectifs_4, t0.livrable AS livrable_5, t0.date_debut AS date_debut_6, t0.duree AS duree_7, t0.unite_duree AS unite_duree_8, t0.budget AS budget_9, t0.experience_dmd AS experience_dmd_10, t0.niveau_etude_dmd AS niveau_etude_dmd_11, t0.auteur_mission AS auteur_mission_12, t0.reference_mission AS reference_mission_13, t0.date_publication AS date_publication_14, t0.statut AS statut_15, t0.cra AS cra_16, t0.facture AS facture_17, t0.titre AS titre_18, t0.modalite AS modalite_19, t0.ville AS ville_20, t0.cp AS cp_21, t0.logo_client AS logo_client_22, t0.confidentialite AS confidentialite_23, t0.localisation_id AS localisation_id_24, t0.admin_id AS admin_id_25, t0.consultant_id AS consultant_id_26, t0.commercial_id AS commercial_id_27, t0.entreprise_id AS entreprise_id_28 FROM missions t0 WHERE t0.id = ?
Parameters: 
[
  "339"
]
View formatted query    View runnable query    Explain query
2 1.56 ms 
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.categorie AS categorie_3, t0.niveau_competence AS niveau_competence_4 FROM competences t0 INNER JOIN missions_competences ON t0.id = missions_competences.competences_id WHERE missions_competences.missions_id = ?
Parameters: 
[
  339
]
View formatted query    View runnable query    Explain query

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\Missions
  • The association App\Entity\Missions#admin refers to the inverse side field App\Entity\Administrateurs#missions which does not exist.
  • The association App\Entity\Missions#consultant refers to the inverse side field App\Entity\Consultants#missions which does not exist.
  • The association App\Entity\Missions#commercial refers to the inverse side field App\Entity\Comerciaux#missions which does not exist.
App\Entity\Localisation No errors.
App\Entity\User No errors.
App\Entity\Administrateurs
  • The mappings App\Entity\Administrateurs#service and App\Entity\Services#administrateurs are inconsistent with each other.
App\Entity\Consultants No errors.
App\Entity\Comerciaux No errors.
App\Entity\Entreprises
  • The mappings App\Entity\Entreprises#service and App\Entity\Services#entreprises are inconsistent with each other.
App\Entity\Metiers No errors.
App\Entity\NiveauEtude No errors.
App\Entity\Competences
  • The field App\Entity\Competences#consultants is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Consultants#competence does not contain the required 'inversedBy="consultants"' attribute.
App\Entity\ReponsesAO
  • The association App\Entity\ReponsesAO#consultant refers to the inverse side field App\Entity\Consultants#reponsesAOs which does not exist.
App\Entity\Evaluation No errors.
App\Entity\EvaluationCON No errors.
App\Entity\EvaluationCOM No errors.