https://dimawork.fr/

Query Metrics

3 Database Queries
3 Different statements
3.80 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 1.77 ms
SELECT count(DISTINCT m0_.id) AS sclr_0 FROM missions m0_
Parameters:
[]
2 0.71 ms
SELECT DISTINCT m0_.id AS id_0, m0_.date_publication AS date_publication_1 FROM missions m0_ ORDER BY m0_.date_publication DESC LIMIT 12
Parameters:
[]
3 1.32 ms
SELECT m0_.id AS id_0, m0_.entreprise_concernee AS entreprise_concernee_1, m0_.contexte AS contexte_2, m0_.objectifs AS objectifs_3, m0_.livrable AS livrable_4, m0_.date_debut AS date_debut_5, m0_.duree AS duree_6, m0_.unite_duree AS unite_duree_7, m0_.budget AS budget_8, m0_.experience_dmd AS experience_dmd_9, m0_.niveau_etude_dmd AS niveau_etude_dmd_10, m0_.auteur_mission AS auteur_mission_11, m0_.reference_mission AS reference_mission_12, m0_.date_publication AS date_publication_13, m0_.statut AS statut_14, m0_.cra AS cra_15, m0_.facture AS facture_16, m0_.titre AS titre_17, m0_.modalite AS modalite_18, m0_.ville AS ville_19, m0_.cp AS cp_20, m0_.logo_client AS logo_client_21, m0_.confidentialite AS confidentialite_22, m0_.localisation_id AS localisation_id_23, m0_.admin_id AS admin_id_24, m0_.consultant_id AS consultant_id_25, m0_.commercial_id AS commercial_id_26, m0_.entreprise_id AS entreprise_id_27 FROM missions m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.date_publication DESC
Parameters:
[
  385
  383
  384
  380
  382
  381
  360
  334
  375
  338
  333
  348
]

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.